Table transformation in Power BI

[SJHALANI]

Hi All,

I have been struggling with transforming a given table to a specific format.

Currently, My table is in this format

I want to transform this table to the format given below:

There are 100s of such currencies in the 1st table.
I want to know what transforation steps could help me get to the desired output. Any help is appreciated. TIA!

[Dhairya]

Hey @SJHALANI 
for getting your expected output you have to pivot your columns.