Is there a way concatenate text from multiple rows into single cell?
I've build a delivery reporting system for a customer and they are looking to link the rounds data with route planning software, however as there are multiple lines generated for the same location (products to be delivered) and as such the route planning software treats them as separate deliveries, is there a way concatenate text from the multiple rows into single cell.
Screenshot example of the data
So for this example I would end up with
Shipping Code | Display Name | To Be Delivered
ST7 2DB | 86 Lawton Road | Product row1, Product row2, Product row3, Product row4, etc...
Thanks