Transposing Row into Column

[MSojo]

Hello... thought transposing would be a little easier, I cannot figure it out. My goal is to have just one column with the following metrics, but instead of on row with multiple measures, I'd like just one column for the measures: 

Desired:

Metric            Value

Date               06/30/2024

Generic           $0

Brand              $51.1M

....                     ...

Category         $8611

I've gone into "Edit Queries", however this appears to take me into the entire dataset. 

I don't wish to transpose the entire set of data, just the table seen above.

Any help would be appreciated!

Thanks,

Matt

[vanessafvg]

try unpivoting instead

https://support.microsoft.com/en-us/office/unpivot-columns-power-query-0f7bad4b-9ea1-49c1-9d95-f5882...