adding a line break in cell with power query

Occasional Contributor

Hi All, looking for some help to insert line breaks in cells with power query.


In column "A" of the attached file is the output of a grouped query in PQ. Whilst i haev added spaces in the text with a ";" I have not been able to perform a query where the data is seperated by a ";" and placed on a new line within the same cell. I can do a concatenate & char(10) as an excel formula I would like to do it via PQ.


Any assiatance would be appreciated.


Cheers, Rob

1 Reply

@robwill100 The PQ equivalent for CHAR(10) is #(lf)