I would like for my spreadsheet to automatically fill in the "cities we sold to" list based on if there is info in the invoice # and invoice amount columns. I have several customers per city, and I need the city to be listed if even one of the customers bought something that day. I'm pretty new to excel, so I hope this is adequate information to get some assistance.
Re: How can I get data from one list to form a new list?
with Power Query (Get&Transform)
City Customer Invoice # Invoice Amount City City 1 Shop City 1 City 1 Generic Automotive City 2 City 1 City Automotive City 1 Fix Your Car City 2 Auto City 2 Morning Automotive City 2 Auto Parts Store City 3 Bla Auto Parts City 3 City Motor Parts City 3 Chevrolet Store
Please Login or Register to view this content.
Last edited by sandy666; 06-08-2023 at 01:43 PM. Reason: M added
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks