Forum Discussion
Solved
Creating a new table in Power BI combining columns
I need to create a new table combining six columns into two columns and keep the identifiers. The exisiting table is: question_id respondent_id Pos1 Pos2 Pos3 Neg1 Neg2 Neg3 1 1 x ...
Hi Jannis68,
If I understand you correctly, you should be able to use the Unpivot Columns option in Query Editor to unpivot the Pos columns and Neg columns separately to get the expected result in your scenario.
For more details about how to Pivot and Unpivot with Power BI, you can refer to this article. :smileyhappy:
Regards
v-ljerr-msft
Microsoft Employee
Microsoft EmployeeHi Jannis68,
If I understand you correctly, you should be able to use the Unpivot Columns option in Query Editor to unpivot the Pos columns and Neg columns separately to get the expected result in your scenario.
For more details about how to Pivot and Unpivot with Power BI, you can refer to this article. :smileyhappy:
Regards