Although you can inject linefeeds (“#(lf)”) and carriage returns (“#(cr)”) in Power Query, lines will not break in the Excel-display. This simple trick makes your lines break nicely in Excel:
- Click into the formula bar
- Click back into your sheet & the lines will be broken:
3. Apply that format to the whole column.
4. Make that format stick for future refreshes: Table Tools -> Design -> External Table Data -> Properties -> Check: “Preserve column sort/filter/layout”
Enjoy & stay queryious 🙂