Forum Discussion
Solved
Pivot the Table
Hi All I want to pivot the table. There is a lot of tutorials to unpivot the table in the power query. However, I want to get the pivot separated by comma like this from the unpivot table. ...
You may refer to the post below.
Hi,
In the Query Editor window (Edit Query), right click on the heading of the second column and under Split columns > Delimiter > Comma, go to Advanced and select rows there. Click on OK. Now each item will appear in its own cell. You can create a Pivot Table.