Forum Discussion
Helper Vsplit columns in rows instead of columns
how is this possible?
For example:
id, Column 1,A;B;C
should become:
id, Column 1, A 1, B 1, C
Yes with PowerQuery Excel or "Get data" with PowerBI Desktop.
The steps depends on the file/format you import the data but with some test and trial you get there.
Import the data , if is one column then select ( under tab Transform ) Split by "delimeter" and the "," and you will have 4 columns. Select the ID column and then "Unpivot Other Columns". Then remove the attribute column and you have the format you needed.
2 Replies
- konstantinos
Memorable Member
Yes with PowerQuery Excel or "Get data" with PowerBI Desktop.
The steps depends on the file/format you import the data but with some test and trial you get there.
Import the data , if is one column then select ( under tab Transform ) Split by "delimeter" and the "," and you will have 4 columns. Select the ID column and then "Unpivot Other Columns". Then remove the attribute column and you have the format you needed.
amienkonstantinosThanks