Forum Discussion
robwill100
Mar 10, 2021Brass Contributor
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
Sort By
- Riny_van_EekelenPlatinum Contributor
robwill100 The PQ equivalent for CHAR(10) is #(lf)
- chris1701Copper Contributor
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
- renee_crozierBrass Contributor
Another hint from over a year later......it is lowercased LF.