Transpose and unpivot table

Hi Rosario,

You have to just do transformation in Advance query editor mode in power bi.

I have taken your sample data and met your requeriments.

kindly have a look and revert me if any concern.

https://drive.google.com/file/d/1NGhZWSTPVcoFwIMNT-aSHoMt9lW59tTh/view?usp=sharing 

Best Regards,

Ravi

Thanks Anonymous, it is exactly as I want it. I will re do it following your steps in edit query. Cheers

Rosario