Text.Combine Seperators

[Gwill1983]

Hi all,

I have grouped my rows of data within power query to ensure that all of my customers orders are combined and the customer name only appears in my table once as below:

Customer	Email Address	Orders
Joe Bloggs		380370
Jon Smith		380139; 380004
Alan Partridge		380536; 380621

this is using the formula below:

= Table.Group(#"Filtered Rows", {"Customer", "Email Address"}, {{"Orders", each Text.Combine([Order Number], "; "), type nullable text}})

Obviously my seperator is "; " but I am trying to find out if there is anyway to split the orders to be on a seperate row within a cell
(ie rather than 380139; 380004 become
380139
380004)

Some customers have alot of orders and the cells become a bit tricky to read with so many numbers alongside each other.

This table is being used for a mail merge to email customers about their orders

Any help is welcomed as I am very new on power query.

Thanks

 

[billszysz]

Text.Combine([Order Number], "#(lf)")

 

[Gwill1983]

Text.Combine([Order Number], "#(lf)")

Thanks alot! That did exactly what I wanted and it looks great in the query editor, but when I close and load my table hasnt changed and the order numbers are just a long number with no seperators!

 

[billszysz]

Thanks alot! That did exactly what I wanted and it looks great in the query editor, but when I close and load my table hasnt changed and the order numbers are just a long number with no seperators!

Select column ( in excel) and click "Wrap text" on menu