Forum Discussion
magc210
Sep 13, 2023Copper Contributor
Move Data Associated with a Zip Code to Another Sheet
Hi everyone! Hoping you can help me out. I have a spreadsheet (sample at Attch 1) with over 3,000 names and numerous zip codes on it. I need to pull the data associated with my 200 unique zip code...
Riny_van_Eekelen
Sep 13, 2023Platinum Contributor
magc210 Easiest done with Power Query (PQ). At least, that's my personal opinion. I replicated your example on a smaller scale. some data in the Data sheet and the PQ output in the Query-MyZip sheet.
If you are not familiar with PQ the link below point to a good place to start.
https://exceloffthegrid.com/power-query-introduction/
But, if your real data is indeed in a six column table and the list of your ZIP codes in one column, you can just copy the 3000 names and addresses into the first table and your 200 ZIPs into the other. Then on the Data ribbon press Refresh All and see what happens. Almost certain that the table of names and addresses for your zip codes shows up in the Query sheet within a few seconds.