Hi Guys/Ladies,
I have this huge set of the dataset of (500K) rows and I need to transport a particular field from column to row. I know how to do Unpivot in PowerQuery but Transpose in PowerQuery is kinda new to me.
As you can see in the sample data, I need to Transpose Product ID, based on Product and Category.
Screen Shot 2017-07-02 at 2.17.51 PM.png
In Excel, I've to create another Column and do a nested CountIf, to create a new column ' Product ID#1, Product ID#2 and so on, and PivotTable. But that is not feasible considering the large set of data I'm working on.
The Final Outcome will look like below
Screen Shot 2017-07-02 at 2.18.02 PM.png
I'm wondering if any of you can help me with the M language for PowerQuery to create the new column for Product ID#1 and so on.
Thanks a lot
Bookmarks