Create a Delivery Run Sheet from All Customer List

%3CLINGO-SUB%20id%3D%22lingo-sub-1733157%22%20slang%3D%22en-US%22%3ECreate%20a%20Delivery%20Run%20Sheet%20from%20All%20Customer%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1733157%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20would%20like%20to%20have%20a%20list%20of%20customers%20and%20addresses%20and%20then%2C%20on%20a%20separate%20sheet%2C%20create%20a%20run%20list%20for%20deliveries.%20This%20list%20will%20vary%20depending%20on%20who%20orders%2C%20obviously.%20Would%20a%20pivot%20table%20work%3F%20Or%20is%20there%20a%20simpler%20way%20of%20doing%20it%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERunning%20Excel%20under%20Microsoft%20365%20on%20a%20PC%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%20Kerry.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1733157%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1733808%22%20slang%3D%22en-US%22%3ERe%3A%20Create%20a%20Delivery%20Run%20Sheet%20from%20All%20Customer%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1733808%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F815856%22%20target%3D%22_blank%22%3E%40Kerry_Todd%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUse%20Power%20Query%20get%20your%20job%20done%2C%20load%20the%20data%20into%20Power%20Query%20slice%20and%20dice%20then%20load%20it%20back%20to%20table..%20if%20are%20still%20facing%20issue%20you%20can%20share%20sample%20data%20with%20your%20desired%20result%20manually%20entered.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ERegards%2C%20Faraz%20Shaikh%20%7C%20MCT%2C%20MIE%2C%20MOS%20Master%2C%20Excel%20Expert%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CEM%3E%3CFONT%20color%3D%22%23808080%22%3EIf%20you%20find%20the%20above%20solution%20resolved%20your%20query%20don't%20forget%20mark%20as%26nbsp%3B%3CSPAN%3EOfficial%2FBest%20Answer%20and%20like%20to%20help%20the%20other%20members%20find%20it%20more%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FEM%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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.

1 Reply

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