how is this possible?
Go to Solution.
to solve your problem step by step, you have to:
1) Select the column
2) Split columns by delimiter (comma)
3) Do the transpose (columns become rows & rows become columns)
4) Split columns by delimiter (semicolon)
5) Replace the null values with the chosen values
6) Redo the transpose
( . . . )
Let me know if it works.
Have a good coding
What If I want to split all columns by delimeter at once ?
Also would like to have the null value showing the correct value.
Should I do that manually by advanced editor ?
It's been some time now, and, columns can be split directly into rows with one step:
How to do the just reverse of this operation.I mean from the shown output to input format.
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
Register by September 5 to save $200
Check out what's new in the Power BI Community!
Continue your learning in our online communities.