Forum Discussion
adding a line break in cell with power query
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
robwill100 The PQ equivalent for CHAR(10) is #(lf)
3 Replies
robwill100 The PQ equivalent for CHAR(10) is #(lf)
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
Another hint from over a year later......it is lowercased LF.
