Forum Discussion
karthik69
3 years agoFrequent Visitor
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...
- 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
karthik69
3 years agoFrequent Visitor
thank you all