Table transform with Pivot

[ngct1112]

Hi all,

May I seek any help for this table transform using query? The "Category" will be shared with the same "ID"

ID	Name	Value
1	Category	Shipment
1	Item	A
1	Price	100
1	Item	B
1	Price	200
1	Item	C
2	Category	Delivery
2	Item	A
2	Price	150

Desired Output:

ID	Category	Item	Price
1	Shipment	A	100
1	Shipment	B	200
1	Shipment	C
2	Delivery	A	150

Appreciated if you have any idea!

[mwegener]

Hi @ngct1112 ,

take a look at the attached sample file.