Transpose range rows by 3 columns into single row by 3 columns

[ExcelNewbie2020]

Gurus,
I am trying to transpose a range of rows by 3 columns into a single row by 3 columns. Please see below;

table 1 is the original format while table 2 is the expected result.

Is there any excel button that can do the transposition? Excel vba can help too.

Thank you very much,

 

[Momentman]

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1	A	B	C		A	B	C	D	E	F	G	H	I	J	K	L
2	D	E	F
3	G	H	I
4	J	K	L
Sheet3

Cell Formulas
Range	Formula
E1:P1	E1	=INDEX($A$1:$C$4,ROUNDUP(COLUMNS($A:A)/3,0),MOD(COLUMNS($A:A)-1,3)+1)

 

[ExcelNewbie2020]

=INDEX($A$1:$C$4,ROUNDUP(COLUMNS($A:A)/3,0),MOD(COLUMNS($A:A)-1,3)+1)

Thanks Man...

 

[Momentman]

Thanks Man...

You are welcome, If the source is 4 columns, you can simply change the 3 to 4 and so on