Want to sort data according to their date but normal sorting will not put all the data of the same date into the same row. See attachment.
Please advise/help.
Thanks.
Want to sort data according to their date but normal sorting will not put all the data of the same date into the same row. See attachment.
Please advise/help.
Thanks.
Arrange your data and use pivot table for getting the desired result. Refer the attached file for solution
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
see attachment solution sheet
Many thanks.
Tried it but due to my 8000+ rows of data, it came up with an error.
Found a way around the problem.
Sort it the normal way ending up with 2 rows of the same date (I want only 1 row per date).
I copy, transpose the data, shift the second row to the left by 1 cell and then transpose again back to the column mode. Then I have 2 data per date row.
Many thanks for your help.
8000 rows of data is nothing for pivot...
It is more than enough
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks