Forum Discussion
Solved
Data does not stay together when I use Sort
Hi there: Sometimes when I sort a column the data in the other columns does not stay together. How do I keep all the data on the numbered lines the same when I sort? For example: If I want to ...
- Hello,
When you sort column B, all other columns A,C-Z obeys the sort other of column B. Definitely, the date column also obeys the column B sort order
Hello,
When you sort column B, all other columns A,C-Z obeys the sort other of column B. Definitely, the date column also obeys the column B sort order
When you sort column B, all other columns A,C-Z obeys the sort other of column B. Definitely, the date column also obeys the column B sort order
I was having the same problem.
The other Columns did not obey the Sort order.
If the Column being Sorted is Column H, then Columns A-H are sorted, and Columns I thru V are left alone. Turns out, I had left a blank column which created a barrier - new table? - and the Sort order stopped there. Columns to the right of the blank column stayed put.
Lots of re-work for me, as I had saved the file and closed the app before I realized it.