How to Unpivot the data for multiple duplicate columns

[infantpowerbi]

Dear All,

I am from Tableau background and my data is in Oracle DB is in below format  with different countires for different years and different quaters columns.
Can any one please help me how can I convert to unstructured data 

Unstructured Data

[ibarrau]

Hi, can you explain a bit more about "A,B,C,D" in the table? if you don't use them, using Q3 2019 in replace of those fields can solve the problem. You can "unpivot" the data in "Edit Queries" in Power Bi.

Regards,

[infantpowerbi]

You Can consider it as Application name

[ibarrau]

Then I think you can merge those rows together like "A Q1 2018". Then you can do the transformation unpivot in Edit queries. This will generate a key value column. The key will be A Q1 2018 and the value the number of the table.

After that you can continue the split column by first space if you want to separate application name from Q1 2018 in two columns.

Hope this helps

Regards,