Transpose on every 9 rows

[JDong]

Hi Team,

I have the below data

ID	Value1	Value2	Value3
1	100	200	300
2	500	600	700
3	400	239	392

Require below output

ID	1	2	3
Value1	100	500	400
Value2	200	600	239
Value3	300	700	392

[FinnCharlton]

Hi @JDong , here's how you do this:

Hope this helps!