Forum Discussion
Anonymous
1 year agoNot applicable
Split multiple columns into one row
Hi Guys,
first off - sorry, I am quite new to PowerBI. I want to know how I can split up these entries (all in one line, divided by line breaks) intro three lines with 1, Niklas, 12, Germany / 2, Joe, 14, French / ...
I know that their is this tool "Divide Columns", however doing this for every column, I end up with 27 rows (3*3*3).
I would be so grateful for any ideas / help.
Best Regards
13 Replies
- rajendraongole1Super User
Hi Anonymous - if possible can you please upload some sample data along with expected output.
- AnonymousNot applicable
- lbendlinSuper User
Please show the expected outcome based on the sample data you provided.