Multiple rows of data to columns

[IH]

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.

[caltang]

Can you provide the .xlsx instead of an image?

[IH]

Just did, thank you

[flying008 · Accepted solution]

Hi, @IH 

FYI.

Input
A	B	C
Age	Gender	Ethnicity
ID	Weight	Eyecolor
Name	Height	Interests
35	Male	Asian
brad123	72	Brown
Brad	180	Football
27	Male	Caucasian
riley345	80	Blue
Riley	190	Basketball
Output
Age	Gender	Ethnicity	ID	Weight	Eyecolor	Name	Height	Interests
35	Male	Asian	brad123	72	Brown	Brad	180	Football
27	Male	Caucasian	riley345	80	Blue	Riley	190	Basketball

******

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

[caltang]

An alternate approach:

[CoG]

@flying008- That's an excellent tool!

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

[IH]

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

Hope you have a wonderful day.