Forum Discussion
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 sort Column B from A-Z and I click on it ... it asks if I would like to expand or continue with current selection. I always hit expand but it does not always keep the data per row together. What am I doing wrong?
- 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
2 Replies
- 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 orderI 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.
