Forum Discussion

buzzb's avatar
buzzb
Copper Contributor
May 03, 2020

how to organise a column so its in alphabetical order and all other columns match

i have a list of countrys, regions, countys and citys all in columns how to I make the country column so its in alphabetical order and the rest of the data does the same?

 

I need to move the data to another excel sheet 

1 Reply

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor

    buzzb 

    You may select your range, Data->Sort, select on which column to sort first (country), add next level of sorting (city), etc.  - as many levels as necessary.

Resources