Hi, I would like to have a list of customers and addresses and then, on a separate sheet, create a run list for deliveries. This list will vary depending on who orders, obviously. Would a pivot table work? Or is there a simpler way of doing it?
Use Power Query get your job done, load the data into Power Query slice and dice then load it back to table.. if are still facing issue you can share sample data with your desired result manually entered.
Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert
If you find the above solution resolved your query don't forget mark as Official/Best Answer and like to help the other members find it more