Tricky Transpose and Sort

**Water Doc** · 11-02-2010, 03:41 PM

First, thank you for looking and any assistance you can provide with this data problem. I have a very large spreadsheet consisting of thousands of rows. I need to transpose the data from columns to rows, but it needs to also sort the data into month/year categories. This may best be done in two separate steps. I have attached a file with two sheets. One is an example of the raw data and the second is the desired format. Any assistance is greatly appreciated.
Thank you

**rylo** · 11-03-2010, 12:56 AM

Hi

See how this goes.

Please Login or Register  to view this content.

rylo

**Water Doc** · 11-03-2010, 03:28 PM

Rylo,
I am thanking the Excel gods right now.... it worked perfectly. Thank you so much.

**Water Doc** · 02-14-2013, 01:38 PM

It has been a couple years since I used this code and tried to use it again today with a new set of data and I keep getting an error. I have attached a new sample data set with the macro. Would you please review it and let me know what I have done wrong.
ThanksData Format-2.xlsm

**rylo** · 03-21-2013, 11:46 PM

Hi

You have changed the structure of the file from the original. In the original, the first appearance of the name also had the first appearance of the data. However, in the new file, the first appearance of the data is in the row below the name.

Restructure your data, and you should be getting somewhere.

rylo