Need help in pivot unpivot the data

[Sarath5c8]

I have an excel data like below

id	value	text
U1	abc	North
U1	fgh	Up
U1	jse	In
U2	abc	South
U2	fgh	Down
U2	jse	Out
U2	fjg	1
U2	qwo	2

which need to be converted to the below i tried unpivot and pivot too but couldnt get it. pls help

id	abc	fgh	jse	fjg	qwo
U1	North	Up	In
U2	South	Down	Out	1	2

[Ashish_Mathur · Accepted solution]

Hi,

See this screenshot