Forum Discussion
Organize an existing spread sheet by date and keep data in other cells within the same row
I have an existing spread sheet that I want to organize all the data by the date and keep the existing data located in different cells but in the same row as the date. How can I do that?
Hi,
If I am reading your need correctly, you should be able to expand your sort in excel to include all data and then sort by the date column (do account for headers if you have any). This should move the data in other cells to the same rows as the date row. Hope this helps!
Best,
bp
If I am reading your need correctly, you should be able to expand your sort in excel to include all data and then sort by the date column (do account for headers if you have any). This should move the data in other cells to the same rows as the date row. Hope this helps!
Best,
bp