create a table from one column
hello everyone,
i am new to the platform, i would like to ask for some help.
i have an excel file where i have all the data in one column like this:
Mark
value A
4
value B
2
Alice
value A
7
value B
1
…
I would like to create a table on KNIME of three columns: Name, value A, value B
in this example the first row after the header: Mark, 4, 2
can anyone tell me the easiest way to do this? thank you very much