Forum Discussion
Excel, table, sorting by column that does NOT affect other columns
Hi, I created a Table in Excel and I want to A-Z sort each column independently of the others. How do I do this? Every time I sort one column it automatically assumes that I want the other columns t...
Your data is not a table (a list of records) because the operation you propose would destroy data records (a process that normally represents in irrecoverable loss of data integrity).
In your case, it is likely that each column should be a separate table, especially if the columns may be of differing lengths.