Transpose column sections into sequential rows of new sheet, Macro help

[ImmunoNut]

Hey guys,

I would appreciate some help so I can import data into a statistics program.

I need to transpose every three cells of a column into sequential rows of a new sheet.

Specifically, for columns 3-49 I need to create a new sheet named after the text of row 1 of each column. Then, for each new sheet, I need to transpose every three cells from the column it was named after into sequential rows. In other words, I need to tranpose the cells in rows 2-4 of that col, into a row in the new sheet, then cells 5-7 all the way to row 283.

Thank you for any hope in advance.

[JBeaucaire]

This should do it:

Please Login or Register  to view this content.

[ImmunoNut]

Thank you so much for your help.

[JBeaucaire]

If that takes care of your need, please select Thread Tools from menu above and set this topic to SOLVED.