Advanced Transpose

Hi all,

I'm wondering if you can help me. I'm trying to move some data about and I seem to have hit a brick wall. I've got a data file which looks something like this:

\1

I'm trying to get it to look like this:

\1

I've tried using the transpose function, but I think this might need something a bit more advanced.

Can anyone offer any suggestions please?

Thanks,

GavM

Thanks for that.

My apologies for not posting a workbook, I just realised how awkward it is to post an image of a spreadsheet!

I've tried that formula, and it almost works. I'd like Sheet1 to end up looking like Sheet3 if possible.

Any suggestions?

Again, thanks very much for your help.

- GavM

Pl see attached file. Sheet2 contains data after running T_pose macro.
In the macro For loop is 1 to 4,because repetetion after every 5 rows.pl change according to your requirement.
Feel free to clarify.
Thanks.