Forum Discussion

techvidya's avatar
techvidya
Frequent Visitor
5 years ago
Solved

Split Rows of Table

Hey guys,   Looking for a solution for below Requirement , I have my table like as shown in below image I have multiple values in Rows of Test Environment COlumn, i want to split those value...
Need Help
  • FrankAT's avatar
    FrankAT
    5 years ago

    Hi techvidya 

    try the following transformation in Power Query:

     

    With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
    FrankAT (Proud to be a Datanaut)

HotChilli's avatar
HotChilli
Community Champion
5 years ago

I think you should be able to right-click and Split Column by Delimiter.

Power Query should recognise a custom character (like line feed).

Use the Advanced option and split to Rows.