Need help in pivot or unpivot of 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

[m_dekorte · Accepted solution]

Hi @Sarath5c8,

Select your "value" column, on the transform tab go to Pivot Column

Set "text" as your values column

Open up the Advanced options and set it to "Don't Aggregate"

Ps. If this helps solve your query please mark this post as Solution, thanks!