Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

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

  • Hi Anonymous - if possible can you please upload some sample data along with expected output. 

     

     

      • lbendlin's avatar
        lbendlin
        Super User

        Please show the expected outcome based on the sample data you provided.