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.