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

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!