Help on Pivot Table

[Anonymous]

I want to create a pivot table for the table below: I am not able to write a correct power query , any help?

[rubayatyasmin]

Hi, @Anonymous 

You do not need to write PQ code to pivot. PQ has pivot/unpivot built-in options. Mostly pivoting can be done using that option. Advanced pivoting might need writing M code in advanced editor. 

from PQ go to Transform tab then click on pivot table. Select the column you want pivot. You might want to see the options below in the Advanced Option tab. 

Or if you can share a demo file of data here, I will be happy to asssit. 

[Anonymous]

Hi, I have attached the screenshot for the sample data with the question.