Move rows into columns

[mrfrobinson1984]

I need a way to move every 7 rows into columns.
So rows 1-7 become columns 1-7, rows 8-14 into columns 1-7 etc.
Anyone know if this is possible? I am great with the stats in excel but anything past that I am lost.

Thanks!

[stanleydgromjr]

mrfrobinson1984,

Welcome to the Excel Forum.

Anyone know if this is possible?

Yes. So that we can get it right he first time:

To get the most precise answer, it is best to upload/attach a sample workbook (sensitive data changed) that contains an example of your raw data on one worksheet, and on another worksheet your desired results.

The structure and data types of the sample workbook must exactly duplicate the real workbook. Include a clear and explicit explanation of your requirements.

To attach your workbook, scroll down and click on the Go Advanced button, then scroll down and click on the Manage Attachments button.

[Pete_UK]

The attached file shows how this can be done. I've set up some data in column A of sheet1 and this formula in A1 of sheet2:

Please Login or Register  to view this content.

which can then be copied across and down as required.

Hope this helps.

Pete

[stanleydgromjr]

mrfrobinson1984,

Welcome to the Excel Forum.

With your raw data in worksheet Sheet1, column A.

The macro (using two arrays in memory) will clear worksheet Sheet2, and, organize the raw data per your instructions.

See the yellow instructions on Sheet1.

Detach/open workbook ReorgData w1 aarray colArows to w2 barray colAthruG - mrfrobinson1984 - EF946444 - SDG15.xlsm and run the ReorgData macro.