Forum Discussion
Multiple Zipcode of one city and one state to be clubbed
My excel file contains unique Zipcodes in column A and the corresponding city in column D and corresponding state in column F. I want to club all Zip codes of a particular city AND a particular state...
Yes. Something like this. But the file contains other columns as well. I am sharing the sample file for you to check.
- OK, but which columns do you want in the output?
- I want all the columns in the output. I have sent the full file to you via private message. Please check. Thanks
I want all the columns in the output
OK, but given Lat & Long are unique per State & City (I didn't look at the other fields), your output will likely have the same #rows as your input. I guess this is not what you expect. Think about it and let me what should be done
I'm gonna be off from the remaining of the day...
