Pivot column in Power Query switches rows to columns, like here:

How to do it?

Select columns you want to transform to columns and click on the “Pivot Column” button.

You can select what happens with values when there are multiple values for some column. I mean if you had multiple numbers for some product and month here.

If this happens and you select “Don´t Aggregate, then “null” appears.

Leave a Reply

Your email address will not be published.

*

clear formPost comment