Transpose columns

[crtakacs]

I'm having trouble understanding the transpose/cross tab tools and I'm trying to convert the results from the first image into something like the second image.

Ultimately I will be adding more data to the table and the Deal_YRMO column will have additional YRMOs (202102, 202103, etc.) with corresponding prices and I would like something that shows up like the second image. Would someone be able to assist? 

[Qiu · Accepted solution]

@crtakacs 

I added some data and hope this is what you need.

[crtakacs]

That works - thanks!