Row Shift

[MROGK]

Hello - How do I get to show the below data table as the Output shown in the 2nd table? thanks

	Type 1	Gross Type 1	Type 2	Gross Type 2	Type 3	Gross Type 3
PINK	CCC	$23	AAA	$15	KKK	$56
BLUE	BBB	$89	TTT	$78	RRR	$32
RED	DDD	$45	CCC	$42	PPP	$78
GREEN	AAA	$12	PPP	$90	BBB	$14

OUTPUT

	CCC	AAA	KKK	BBB	TTT	RRR	DDD	PPP
PINK	$23	$15	$56
BLUE				$89	$78	$32
RED	$42						$45	$78
GREEN		$12		$14				$90

[christine_assaad · Accepted solution]

Hi @MROGK 

Please check this workflow out

[Thableaus · Accepted solution]

Hi,

Here's my contribution. WF attached.

Cheers,

[MROGK]

thankyou very much.