Row To Column

[Ekmi9]

Hello Everyone,

I have one input set like 

A	B	C	D
xyz	1	3	5
opq	2	4	6
A	E	F	G
xyz	7	10	13
opq	8	11	14
abc	9	12	15
A	H	I	J
xyz	16	18	20
ghi	17	19	21

and i wanted to convert this into :

A	B	C	D	E	F	G	H	I	J
xyz	1	3	5	7	10	13	16	18	20
opq	2	4	6	8	11	14
abc				9	12	15
ghi							17	19	21

Appreciate your help 

Thanks in advance !

[flying008]

Hi, @Qiu 

I've always had confusion about this option [Out fields change based on macro's configuration or data input.], when to choose it and when not to choose it? What's the difference? Could you please explain with a case ? thanks a lot ! 

[DavidP]

Hi @Ekmi9 

I've had a rethink and came up with a slightly different method as shown below - I used in-workflow documentation to explain the various steps.