Changing Multiple Columns into Multiple Rows

Hello. I'm trying to create a macro that can change multiple columns into multiple rows. I found the following topic which was close, but I wasn't able to tweak the macro to get it to do what I wanted. http://excel.bigresource.com/Track/excel-OzKIXK1u/

I've attached the file with an example of what I'm trying to do.

Basically, Columns A-E would need to be duplicated 12 times. The headers from Columns F-I would need to be the values in Column F for those rows, and the values from Columns F-I should be the values for Column G and the values from columns J-M should be the values for Column H.

The excel file demonstrates it a little better.

This is the macro I've been trying to tweak, unsuccessfully:

Please Login or Register  to view this content.

Thanks,
Tester36

Hi Tester36 and welcome to the forum.

Find the attached with code that will do what I think you want. Run the code and build your new table.

This was excellent. Thank you Marvin.

I modified the code by duplicating all the lines to go up to +23 instead of +3, because I had 24 rows of data values instead of 4. Worked perfectly!

Regards,
Tester36