Transform single column to multiple columns

My Data (Column headers and data) is all contained in in one column.
How do I transpose it to Multiple columns with the correct data in each row?

Thanks for any support.

hi @AidanByrne,

how you want the column header to match to the rows?
Only through the numbers in the header/row?
Seems like a bit strange layout, but I guess. its doable :thinking:

1 Like

Hi @AidanByrne

See this wf. It uses a Chunk loop . To process (in my example) 3 rows at the time. Transform_single_column.knwf (33.9 KB) .

gr. Hans


Thanks for the reply,
I need Column Header 1 match Data B1 and C1 etc.

Thanks Hans,

I think that will do what I need.

1 Like

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.