I’m still new in knime and struggling…
I have a table (about 4000 lines) which has one column, it is a regroupement of item id. I also have the rowid. Example of the table:
I want to have something like that at the end:
A12 Row1 Row2
How can I do that? I was thinking about spliting the cells, then doing a loop to merge with another table I have (the list of all items id). But I was wondering whether there is an easier way to go. Transpose sounded good to me but it didn’t work.
Thank you very much for your help!