How to put columns in alphabetically order in a matrix?

[Anonymous]

I am trying to sort my column headers (“no goal level”, “platinum”) alphabetically, but I don’t see a way to do this. I can only sort by “vertical” columns, by agency name and the employee count. What I want is the columns to appear "Gold, Gold Plus, No goal level, Platinum, Silver". 

The “sort by column” is grayed out because I am connected to live data. Also, there is no option for this type of sorting on the menu, as can be seen in my screenshot. 

How can I get this done?

[claymcooper]

Try setting up a "sort order" column or table and sort the current level alphabetically. Gold = 1, Gold Plus = 2, etc

[claymcooper]

Looks like this is in a matrix. Have you tried manually ordering them in alphabetical order in the column input area?

[Anonymous]

Hi Clay, yes it's a matrix, I should have mentioned that.
There is no choice for ordering there. It's only the "current level".  Any other ideas?