I have an excel worksheet in which I want every 8 rows transposed into columns. I have tried recording a macro, but this does not loop through the data.
For example, I want Colmun B, Row 2-9 in Row 2, Columns C-H. Then Column B, Row 10-17 in Row 3, Columns C-H and so on....
Any help would be greatly appreicated. I would love a macro to run!
For example, I want Colmun B, Row 2-9 in Row 2, Columns C-H. Then Column B, Row 10-17 in Row 3, Columns C-H and so on....
Any help would be greatly appreicated. I would love a macro to run!