How to change data from long to wide format with multiple columns

[overhead_press]

I have the below dataset and I want to transform every three rows into one row

1	2	3	grouping	sequence
123	A	B	1	1
ABC	C	D	1	2
USD	E	F	1	3
567	G	H	2	1
DEF	I	J	2	2
USD	K	L	2	3

Desired results (column names don't matter): 

1	2	3	4	5	6	7	8	9
123	A	B	ABC	C	D	USD	E	F
567	G	H	DEF	I	J	USD	K	L

Thanks in advance!

[JosephSerpis · Accepted solution]

Hi @overhead_press I mocked up an approach that use the Transpose Tool and the Multi Row tool to work out the correct columns and then use a crosstab to pivot the data horizontally.