Forum Discussion

PhilippeMuniesa's avatar
PhilippeMuniesa
Resolver I
3 years ago
Solved

Pivot Table (Difficulties in making a pivot table)

Hi,   I've been needing help creating a pivot table for several days and all my attempts have failed.   I start from a table of the type.   Mois rubrique valeur Nss bloc 1 R_Principa...
Need Help
  • vaibhavkale570's avatar
    vaibhavkale570
    3 years ago

    You can achieve this using power query editor. 

    select  Rbrique column and click on Pivot column option in transform tab.

    and remove unnecessary columns.  

     

    you will get result like this

     

PhilippeMuniesa's avatar
PhilippeMuniesa
Resolver I
3 years ago

 

vaibhavkale570

 

Good evening,

I don't understand why I couldn't do it using the same technique, if not because I had other columns (indexes) etc. used to modify the table, and I hadn't deleted.

 

Thanks to you, I deleted the extra columns and actually saw a correct result. A big thank you because now I can continue to build this project.

 

Philippe