Rearrange groups of columns, with multiple rows

[gromitnz]

Hiya

I have a 'table' of data (not an actual table, though this might be the right direction) that has 'groups' of 4 cells; x4 'groups' wide. And then continues on for many rows worth.
I want to reference the data into 4 new columns, (with clearly 4x as many rows).

Heres an example: (numbers and text are in practice all numbers, but this clearer identifies the data groups)

0 CAT DOG FISH 1 SQUARE CIRCLE TRIANGLE 2 CUP SPOON KNIFE 3 UP DOWN LEFT
4 HAT GLOVES COAT 5 PEN PENCIL ERASER 6 CAR TRUCK BUS 7 HARD SOFT SQUISHY
8 MAN LADY KID 9 PC MAC PLAYSTATION 10 HORSE COW SHEEP 11 PLASTIC METAL WOOD

Desired new list:

0 CAT DOG FISH
1 SQUARE CIRCLE TRIANGLE
2 CUP SPOON KNIFE
3 UP DOWN LEFT
4 HAT GLOVES COAT
5 PEN PENCIL ERASER
6 CAR TRUCK BUS
7 HARD SOFT SQUISHY
8 MAN LADY KID
9 PC MAC PLAYSTATION
10 HORSE COW SHEEP
11 PLASTIC METAL WOOD
and so on...

Attached is the actual sheet, and my start on the right hand side is where I have manually referenced the cells to indicate what I need to achieve. Ignore the RAW sheet, this is where I paste the data from my Modem.
The sheet probably makes a lot more sense than my example above; to be fair...

Thanks in advance.
I know there must be some formula that will do this, somehow referencing cell by row and col number or similar, but the formulas I have seen for collapsing columns into rows etc don't account for my groups of 4 across.

Any help greatly appreciated! You guys have been magic in the past!

Paul

[leelnich]

Hi gromitnz- Paste this in S2, copied across and down:

Please Login or Register  to view this content.

The formula could easily be altered to pull data directly from your RAW sheet if columns A:P serve no useful purpose:

Please Login or Register  to view this content.

[gromitnz]

You fine sire, are a magician. Good Karma your way. I love this place.
The help is much appreciated, and I enjoy reverse engineering the formulas to try and work out how they're built.
Thanks, I like the version that pulls the info direct from the RAW sheet.
Fab!

[leelnich]

Thank you for the kind thoughts. If that completes your thread, please go to Thread Tools up top and mark it SOLVED. Regards -Lee