Forum Discussion
Kerry_Todd
Oct 01, 2020Copper Contributor
Create a Delivery Run Sheet from All Customer List
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...
Oct 01, 2020
Hi Kerry_Todd
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