how to transform text in the same cell into new lines in power query

[Sian1]

Hi, hope all is well.
does anyone knows if i could transform the cell eg Reason - Review; Manager Approval into Review in the same cell? for easy reading
Approval

ID	Date	Reason	Comment
ab123	2/10/2022	Review; Manager Approval	being processed ; waiting for approval

ID	Date	Reason	Comment
ab123	2/10/2022	Review; Manager Approval	being processed ; waiting for approval

 

[RoryA]

Do you mean you just want to add a line feed after the semicolon(s) in the result table so that the items are each on a separate line within the cell?

 

[Sian1]

Do you mean you just want to add a line feed after the semicolon(s) in the result table so that the items are each on a separate line within the cell?

yes

 

[Sian1]

yes

semicolon with linefeed

 

[RoryA]

In the PQ editor, you can use the replace values option to replace ; with ;#(lf) and then all you need to do is apply Word Wrap to the column in the result table.

 

[Sian1]

In the PQ editor, you can use the replace values option to replace ; with ;#(lf) and then all you need to do is apply Word Wrap to the column in the result table.

perfect! thanks so much

 

[RoryA]

Glad we could help.