Items in a column into rows?

[Bee008]

Hello,

I need some help with moving some data, which is presented in columns, into separate rows.

It makes much more sense when you can see it Book1.xlsx

As you can see, my data output shows everything listed in a column. But for each 'face' I want to put 4 of the cells into rows.
So, dark blue C3-C6 needs to be moved into separate rows, demonstrated in E2-J2.

I need to do this with every 'face'. So, in total, I need to do it 2160 times! What's the quickest way? (note: the 'trigger', and 'trigger off' cells can be filtered out of the spreadsheet)

I will be so grateful for any help! As I really am not that great on Excel.

Thanks for reading,
Bee x

[ufopilot]

Once you have established a pattern of how cells are moved in relation to each other, you can use that pattern with a formula to read and place the cells in the columns into rows.
I have used the pattern of the first two entries you have made into rows, and copied the pattern down 2255 times.
- Of course the formula runs out of populated cells to read in your example. But you can use this method. Then copy all the formulas, and paste values only, before deleting the columns of data.
HTH

[JohnTopley]

See attached with the 'trigger', and 'trigger off' cells filtered out