Transform single column to multiple columns

[AidanByrne]

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.

[AnotherFraudUser]

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

[HansS]

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

[AidanByrne]

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

[AidanByrne]

Thanks Hans,

I think that will do what I need.