Multiple Header Output

[praneshsapmm]

Hi ,

I have my input data as mentioned below : 

ColumnA	ColumnB	ColumnC
A	1A	1
B	1B	1
C	1A	1
D	1D	1

My output need to be :

A	B	C
1A	1B	1A
1	1	1

Thanks

[AZuc]

@praneshsapmm 

See if it works for you

[praneshsapmm]

Hi @AZuc ,

Can you send me .yxmd format of it.

Thanks.

[AZuc]

@praneshsapmm there it is

[praneshsapmm]

Hi @AZuc ,

Sorry my requirement changed a bit .It is actually like this .

Column A	Column B	W	E	M	S
A	1A	1	1	1	1
B	1B	0	0	0	1
C	1A	2	1	1	1

Expected Output is :

	A	B	C
	1A	1B	1A
W	1	0	2
E	1	0	1
M	1	0	1
S	1	1	1

Can you help . Thanks.

[Jonathan-Sherman]

Hi @praneshsapmm,

You'd just need to make a few small additions to @AZuc's workflow and you could solve it!

I've attached my workflow for you to download if needed!

Kind regards,

Jonathan