Pivot Table (Difficulties in making a pivot table)

Question

Hi,&nbsp;I've been needing help creating a pivot table for several days and all my attempts have failed.&nbsp;I start from a table of the type.&nbsp;MoisrubriquevaleurNssbloc1R_Principale1&nbsp;&nbsp;&nbsp;&nbsp;V_Principale1&nbsp;V_Principale111R11VR1A&nbsp;V_Principale111R21VR2A&nbsp;V_Principale111R31VR3A&nbsp;V_Principale111R41VR4A&nbsp;V_Principale111R11VR1B&nbsp;V_Principale121R21VR2B&nbsp;V_Principale121R31VR3B&nbsp;V_Principale121R41VR4B&nbsp;V_Principale121R_Principale2V_Principale2V_Principale231R11VR1CV_Principale231R21VR2CV_Principale231R31VR3CV_Principale231R41VR4CV_Principale232R_Principale1&nbsp;V_Principale1&nbsp;V_Principale142R12VR1A&nbsp;V_Principale142R22VR2A&nbsp;V_Principale142R32VR3A&nbsp;V_Principale142R42VR4A&nbsp;V_Principale142R12VR1B&nbsp;V_Principale152R22VR2B&nbsp;V_Principale152R32VR3B&nbsp;V_Principale152R42VR4B&nbsp;V_Principale152R_Principale2V_Principale2V_Principale262R12VR1CV_Principale262R22VR2CV_Principale262R32VR3CV_Principale262R42VR4CV_Principale26&nbsp;&nbsp;The result to be obtained is as follows: Would any of you be kind enough to help me find a solution?&nbsp;NssblocMoisR1R2R3R4&nbsp;V_Principale1111VR1A1VR2A1VR3A1VR4A&nbsp;V_Principale1211VR1B1VR2B1VR3B1VR4B&nbsp;V_Principale1422VR1A2VR2A2VR3A2VR4A&nbsp;V_Principale1522VR1B2VR2B2VR3B2VR4BV_Principale2311VR1C1VR2C1VR3C1VR4CV_Principale2622VR1C2VR2C2VR3C2VR4C&nbsp;Thank you in advance because I am really at an impasse&nbsp;Attached table and desired result in Excel&nbsp;https://www.dropbox.com/t/4dEgRk2QmbNv22AP&nbsp;&nbsp;Philippe Muniesa&nbsp;&nbsp;&nbsp;&nbsp;

vaibhavkale570 · Accepted Answer

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

Forum Discussion

Pivot Table (Difficulties in making a pivot table)

2 Replies

Related content

Authenticating OData.Feed using Web API difficulty

POWERBI LOGIN DIFFICULTY

Make a table or matrix transparent

Difficulty making a cumulative total each day

Difficulty in unpivoting Table

Mois	rubrique	valeur	Nss	bloc
1	R_Principale1	V_Principale1	V_Principale1	1
1	R1	1VR1A	V_Principale1	1
1	R2	1VR2A	V_Principale1	1
1	R3	1VR3A	V_Principale1	1
1	R4	1VR4A	V_Principale1	1
1	R1	1VR1B	V_Principale1	2
1	R2	1VR2B	V_Principale1	2
1	R3	1VR3B	V_Principale1	2
1	R4	1VR4B	V_Principale1	2
1	R_Principale2	V_Principale2	V_Principale2	3
1	R1	1VR1C	V_Principale2	3
1	R2	1VR2C	V_Principale2	3
1	R3	1VR3C	V_Principale2	3
1	R4	1VR4C	V_Principale2	3
2	R_Principale1	V_Principale1	V_Principale1	4
2	R1	2VR1A	V_Principale1	4
2	R2	2VR2A	V_Principale1	4
2	R3	2VR3A	V_Principale1	4
2	R4	2VR4A	V_Principale1	4
2	R1	2VR1B	V_Principale1	5
2	R2	2VR2B	V_Principale1	5
2	R3	2VR3B	V_Principale1	5
2	R4	2VR4B	V_Principale1	5
2	R_Principale2	V_Principale2	V_Principale2	6
2	R1	2VR1C	V_Principale2	6
2	R2	2VR2C	V_Principale2	6
2	R3	2VR3C	V_Principale2	6
2	R4	2VR4C	V_Principale2	6