Forum Discussion
Solved
Transforming columns into row values
Hi, I am doing a Net Promoter Score report were our customers are being asked different questions. In six of the questions they can write comment. In my dataset all questions is a column, an...
Hi,
in power query select all the question columns, right click and unpivot them, this will put all the questions in one column and the answers in the column next to them.
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
hi SimonMalberg You can merge all those tables by clicking Merge at top of ribbon and select columns you want to unpivot then click on UNPIVOT.
See the images below for your reference.