Forum Discussion
infantpowerbi
Helper II
Helper IIHow to Unpivot the data for multiple duplicate columns
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 c...
infantpowerbiHelper II
Helper IIYou Can consider it as Application name
ibarrau
Super User
Super UserThen 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,