Hi All
I am desperate to solve this and im sure your powerful brains can sort this problem in seconds. Well here go's, I have a data set with multiple columns of data and dates, I need to sort the columns by dates so that each row has the same dates on it. Also need to sort each set of dates by various other data columns. So if i have a 30 dates in column A then they match up to the dates in column F but this may only have 10 dates. This is a massive data set of over 30k rows and really dont want to go through inserting rows every time i see a date change.
I have attached a small amount of the data set.
I am probably not explaining this very well but hopefully you can figure out what i am after.
Thank you so much for any help that you can offer.
Mac
Bookmarks