Forum Discussion

karthik69's avatar
karthik69
Frequent Visitor
3 years ago
Solved

Split Column based on Delimiter in to Rows based on the Condition

Hello,   Thanks for seeing this Question.   I'm trying to find a solution to split column in to rows based on the Value in the Column.   In my scenario the text that determines the split is 'Ne...
  • MahyarTF's avatar
    3 years ago

    Hi,

    In Power Query I did copy twice from particular Table :

    1- in the first one, 

    A- I add Custom Column and use below M code : if Text.Contains([Desc], "New") then "New" else ""

    B- Filter the new Column just for the rows including 'New'

    C- Remove the Desc Column and rename the new column to Desc

     

    2- In the second one,

    A- I Replace the New with Space for Desc Column

    B- Replace ", ," with ","

    C- Trim the Desc Column

    D- RightTrim the "," from the end 

    3- Now if Append these two ones together, the new table is included the particular rows :

     

    Appreciate your Kudos