Sorting data by columns

Question

I need to sort/filter data in my sheet and have the data to move with the sort

I need it to be done by location and then the next column to be done by name and another by date

it also keeps adding my header right under the one thats already there and moving the data where it shouldnt be

do i need to create a list to sort data? or what do i do

oliverscheurich · Answer

Amber1023&nbsp;=SORTBY(A2:C11,A2:A11,1,B2:B11,1,C2:C11,1)You can try&nbsp;SORTBY.&nbsp;

amber1023 · Answer

will it keep all my other data in those rows with it when it sorts or do i do it by the columnor doin need to have it sorted/filtered left to right

oliverscheurich · Answer

Amber1023&nbsp;Does the suggested formula return the intended result? If it doesn't can you give an example of your data and of the intended result?

amber1023 · Answer

This is the data i need in a table or sheet then i need to have it all added again for this current year so i can keep a running list going of every years data and view it next to each other as a comparisonhow do i do this/make itOliverScheurich&nbsp;

Forum Discussion

Sorting data by columns

4 Replies

Resources