Hello KNIME community!
I hope you all have a good start in 2023 and a very good year.
Can you please help me to transpose data in a special way? I just can’t find out how to do it.
I have a table, that looks like this:
Now I’d like to convert it, that it looks like this:
Do you have a good idea? I’m looking forward to your answers.
create new column where you’ll have Name Word, Name Number… values which are corresponding to your first column. Then use Pivoting node with no group column, pivot column your newly created column and aggregation List on your existing column. Finish it with Ungroup node.
Hope this helps and all the best to you in new year.