How to change the column order in Excel table with multiple sort

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an Excel table, have sorted it on 4 levels. Is there a way to change
the column order in the table so that the information gleaned in the sort is
clear? In other words, I'd like the column order to mirror the sorting
levels.
 
Nothing automatic that's built into excel.

But you could drag and drop the columns where you want them after you sort.

Personally, I think I'd find the changing of the layout more confusing that
determining how the data was sorted.
 
Back
Top