Pivot Table help

[harinder1301]

Hi 

I would like to change my output to the below format using Pivot Tool.

Rownum	ID	a1	a2	a3	a4
1	100	abc1	50	xyz1	20
2	200	abc2	90	xyz	10
3	300	abc1	40	xyz	30

ID	Column	Value
100	abc1	50
100	xyz1	20
200	abc2	90
200	xyz	10
300	abc1	40
300	xyz	30

Appreciate your advise on this.

Thank You in Advance.

[atcodedog05]

Hi @harinder1301 

If you have only 2 columns then easy to do it is like below.

Let me also work on a dynamic method.

Hope this helps : )

[atcodedog05 · Accepted solution]

Hi @harinder1301 

Here is a dynamic workflow.

Hope this helps : )

[binuacs · Accepted solution]

@harinder1301 

[harinder1301]

Perfect ! Thank you.

[harinder1301]

Both solutions worked for me.Thank you!

[atcodedog05]

Happy to help : ) @harinder1301 

Cheers and have a nice day!