Macro to Transpose multiple rows to one colums

Hello,

I apologize for asking a question similar to one that was recently answered. However, I am not too experienced with macros, and I have trouble following the original macro in order to adjust it to my situation.

The original thread is here:
http://www.excelforum.com/excel-2007...iple-rows.html

I would really appreciate help in editing the macro so that it could be applied it to my example.

Thank you.

'ROWS TO COLUMNS
Here's a macro for expanding rows of data to multiple rows parsing out the values in the row while duplicating the header row as categories. There's a sample workbook too you could drop your data into and test it out.

Rows to Columns - Part 1a

Using that as a starting point, I tweaked that for your workbook as follows:

Please Login or Register  to view this content.