Transpose Help

[DanielW17]

Hi,

My data looks like this:

Company	Taste	% Liked
Snickers	1	95%
Mars	2	45%
Skittles	3	33%

I want it to look like this:

Company	Metric	Value
Snickers	Taste	1
Snickers	% Liked	95%
Mars	Taste	2
Mars	% Liked	45%
Skittles	Taste	3
Skittles	% Liked	35%

Can someone please help?

Thank you

[binuacs · Accepted solution]

@DanielW17 you can transpose the given data

[IraWatt]

Hey @DanielW17,

Just need to key column by company:

[DanielW17]

Thanks bud!