Multiple rows of data to columns

Hi, I've tried searching with no luck,

I have an awful looking set of data which looks something like the left where sets of data repeat every three lines.

I've got to the point where I have an index column that repeats itself with Record ID and a formula which uses Mod([RecordID]-1,3)=1.

However I can't wrap my head around how to use this repeating index of 1-3 to spread out horizontally from the current data.

The actual data has repeating sets of data which stretch 16 columns and 3 rows.

Thank you in advance and happy new year everyone.

Datasets

Accepted answers

Hi, @IH

FYI.

录制_2024_01_05_16_20_55_494.gif

******

If can help you get your want, please mark it as a solution and give a like for more share.

Can you provide the .xlsx instead of an image?

Just did, thank you

Hi, @IH

FYI.

录制_2024_01_05_16_20_55_494.gif

******

If can help you get your want, please mark it as a solution and give a like for more share.

An alternate approach:

@flying008- That's an excellent tool!

Also, building off of @caltang's, here is another variant for the solution:

Thank you so much, this tool solved the task like it's nothing.

Hope you have a wonderful day.