Table Transformation

Hello SJHALANI ,

Please follow below steps to achieve it:

1. You have to duplicate the table remove blank columns and other columns by keeping only two columns for each currency type in one table. 

2. Use first row as headers two time to get date and PX value at top, then create a custom column saying Currency Type". Then the table looks as below:

3. Now after creating tables like that append them to create third table. Output looks like this:

4. After loading data into Power BI desktop, create a Matrix visual which will creates report as you need. Please refer to below screenshot for the same:

If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!