Pivot three columns, one with an ID column to rows

[laganlee]

Hi, 

I have three columns

and I need it pivoted to this: 

Any suggestions would be highly appreciated!

[dufoq3 · Accepted solution]

Hi @laganlee,

Result:

[laganlee]

Many thanks!

That's much appreciated 🙂 

[AlienSx]

[laganlee]

That's really interesting - I'll have a go at that as well.

Many thanks 🙂