Returning multiple results in one cell

[00264657]

The Excel file shows cities and what county they are in. Instead of it being seperated, I would like all the cities in one county such as
"West Palm Beach, Riviera Beach" in one cell and Palm Beach County as their county instead of them being separated.

Can you please explain the formula used so that I can expand the concept to include zip codes as well if possible ? Thank you.

[#2]

Hi 00264657,

Do you need the output for Country as it is there for Zip codes for "West Palm Beach, FL" ?

I am referring cell D5011 as output for Zip codes.

Regards,

DILIPandey

[#3]

Dilip, i guess for County, not Country; and that's continuation of this https://techcommunity.microsoft.com/t5/Formulas-and-Functions/Matching-Zip-Codes-to-City/m-p/74093#M... task