I am trying to use the Pivoting node to convert rows -> columns without duplicating / adding suffixes to the new [Screen Shot 2020-07-14 at 10.46.47 AM] columns. I am working with multiple spreadsheets acting as forms, ie. each respondent is presented with questions (listed as rows) and responds with their own response. I want to convert the questions to columns and have each response listed under the question, but my problem is that KNIME is insisting on creating a unique Row ID for each question, though they are identical. Any ideas?

Transpose with multiple sheets without duplicating columns

mlauber71 July 20, 2020, 6:24am 8

You could take a look this workflow that hopefully does what you want:

1 Like