I have a raw data below and require certain transofmation and any advise/solution will be helpful.
I have a column name Quartely Breakdown and it contains information as shown below.
I wish to obtain a desired results below.
I have tried unpivoting and pivoting the columns but still could not get the desired results. Thanks in Advance!
Go to Solution.
To achieve it, you could first split the column based on the delimiter “semicolon”, noted in “Advanced options”, select “rows”.
By doing this, the column will become
Then split the column again. This time only need to set delimiter as “Colon”:
And the final result is like:
View solution in original post
Check out a full recap of the month!
Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.