Forum Discussion
Combining rows of data (separate columns) in one row
Hello everyone, I have a big data sheet (multiple thousands of rows), which is an export-file from a questionnaire. We are setting up PowerBI to work on this in the future, but we're not there ye...
PeWe76 This seems to be something for PowerQuery in Excel or inPower BI. But you didn't upload a file, though you refer to examples in Blad 1 and Blad2.
Riny_van_Eekelen I know Power BI would be an option here. We are installing it at this moment and setting it up correctly, but time is not on my side, so I try to find a quicker solution.
If you could take a look at the file I attached, maybe you can see an 'easy' solution?
Thanks in advance.
With Power Query you may unpivot other than ID columns and after that pivot on questions. You may check steps in attached file.
SergeiBaklan ; it seems to work!! Thank you very much.
PeWe76 , you are welcome
