Same Column Rows to Header

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)

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

1 Like

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.


Thanks for the tricks boys :smiley: