Custom Table or Matrix based on the ranking on the Rows

Hello All,

I need to create the below table based on the ranking on rows with the product and sales concatenation, Please some body explain how to create this.

Ranking should based on the row headers.

Thank you in advance.