Column values as header : how to transpose the table

[ochaoui]

Hi folks,

I have a table like this coming from a json :

app name	name	value
A	description	XXXX
A	display name	YYYY
A	note	ZZZZ
B	description	QQQQ
B	display name	SSSS
B	note	DDDD
C	description	WWWW
C	display name	BBBB
C	note	CCCC

I want to transpose this table in order to have a header that contains the values of the "name" column.

As a result, I would like to have this :

app name	description	display name	note
A	XXXX	YYYY	ZZZZ
B	QQQQ	SSSS	DDDD
C	WWWW	BBBB	CCCC

How to do that with power query GUI pls ??

Thanks in advance.

Regards,

[Jagen007]

Greeting,

This is my table design is as below.

Order No.	Material	Delivery no.
ABC-11	245678	400000000
ABC-12	245678	500000000
ABC-13	245678	600000000

My desired output is in this table format.

Order No.	Material	Delivery no.	Delivery no.	Delivery no.
ABC-11	245678	400000000	500000000	600000000

Kindly please help to advise how to solve this in Power Query or Power BI.

[Jagen007]

V-pazhen-msft

V-pazhen-msft

[Anonymous · Accepted solution]

@ochaoui 
For detail, select the name column=>pivot column=>select value as values column=>choose don't aggregate.

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[HotChilli]

That's a Pivot from the Transform menu