Same Column Rows to Header

[prashant]

Something tricky for me. Convert Row 1-4 to Columns

One way to do this

How else to achieve this?

MyTransform.transform (5.0 KB)

[Admin]

You probably want to check Has header in the Transpose transform.

[Olaf]

and if you have the input in one file, add 2 parallel filter transformation on the first column. One “if column 1 is not empty” and the second “if column 1 is empty” and then proceed as in your example with the check set in the transpose, as suggested by admin.

[prashant]

Thanks for the tricks boys