The ability to move columns in Excel is a great benefit when dealing with long strands of data in Excel. You can easily move a column into another column, regardless of whether or not the other column ...
Nest CHOOSECOLS inside UNIQUE to extract non-adjacent columns, and use INDIRECT for interactive header dropdowns.