How to convert data in rows to column headers and move data

[Anonymous]

Hi All, 

A bit stumped with this:

I need to convert data in "results.data.metrics.metric" to column headers and then replace that data with "results.data.metrics.stats.count", "results.data.metrics.stats.max", "results.data.metrics.stats.min", "results.data.metrics.stats.sum" and also move the corresponding data.

This is what it looks like currently:

This is what I'm trying to achieve:

Have tried to transpose and pivot operations but no success. 

Apologies if the title is unclear! Any solutions will be highly appreciated!

[vanessafvg]

i think you need to pivot rather than transpose.  

https://www.youtube.com/watch?v=li0c6R6UpCw