Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
how is this possible?
For example:
id, Column 1,A;B;C
should become:
id, Column 1, A 1, B 1, C
Solved! Go to Solution.
Hi amien,
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
How to do the just reverse of this operation.I mean from the shown output to input format.
It's been some time now, and, columns can be split directly into rows with one step:
Hi,
I am attempting to use this option. The window that pops up looks exactly like your image, but the option for columns or rows in the middle is just missing. The original choices from Get & Transform only allowed From Table. There was no From Table/Range option. Any direction you might provide would be so helpful.
Hi amien,
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 ?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
117 | |
107 | |
70 | |
70 | |
43 |
User | Count |
---|---|
146 | |
106 | |
104 | |
89 | |
65 |