Forum Discussion

Kerry_Todd's avatar
Kerry_Todd
Copper Contributor
Oct 01, 2020

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 work? Or is there a simpler way of doing it?

 

Running Excel under Microsoft 365 on a PC

 

Thanks, Kerry.

excel

1 Reply

  • ExcelExciting's avatar
    ExcelExciting
    MVP
    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

Resources