transposing a column

I have a very simple table with no data as below.

image

the output needed is the column 1 values as table columns with empty data as below

image

how do i do this
Thanks in advance

Hi,
First you need to turn your column into a Row ID with the RowID node, then you can use the Table Transposer node to turn them into columns.
Kind regards,
Alexander

4 Likes

Interesting solution @AlexanderFillbrunn. It could be added as an example to the brochure “From Excel to KNIME” demonstrating KNIME replacement for Excel special Paste case with transpose.

2 Likes

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