Combining / Stacking Columns

This might be straight forward, but I am trying to combine responses from 10 companies and I am struggling for the best method to accomplish this. I would like to output my results to Excel such that I have Product Values for each company in one column. Any suggestions on how to accomplish this?


Can you try Unpivot node? Top column selection include only the two product type columns (furthest to the right) and in the bottom all except those two.

That should get you close - will likely give you missing values for where there is only one for product A or B and not both.

Think there is a setting in the node to ensure no rows with missing values get generated - will check and edit later.


That may have done it. Thanks so much for the assist!

1 Like

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