adding a line break in cell with power query

[robwill100]

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

[#2 · Accepted solution]

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

[#3]

@Riny_van_Eekelen 

Thanks that saves me a lot of time. 

Just a hint to annyone who tries this: #(lf) needs to be quoted to "#(lf)" and the cells in the table need to be formated with Wrap Text