Concatenated data in subsequent rows

Hey there!

New to the forum and need some help ASAP. Hopefully I can adequately explain what I am trying to do:

We would like to list concatenated city names and services. I am trying to have it so we can use a VLOOKUP-type function where if we type in a city name, that city's concatenated data appears in another row. Here's the kicker - we would like to be able to type in other city name in that same original cell and have that new city's concatenated data appear under the first city's data. It would look something like this:

SERVICE1CITYNAME1
SERVICE2CITYNAME1
SERVICE3CITYNAME1
SERVICE4CITYNAME1
SERVICE1CITYNAME2
SERVICE2CITYNAME2
SERVICE3CITYNAME2
SERVICE4CITYNAME2
SERVICE1CITYNAME3
SERVICE2CITYNAME3
SERVICE3CITYNAME3
SERVICE4CITYNAME3

Etc.

Any help would be greatly appreciated, as I am under the gun here!

Originally Posted by Mordred

It might be best for you if you upload a mock workbook with mock/non-sensitive data in it. If you do that you'll probably have an answer faster.

Regards:

Good idea! It is attached here.

Try putting this in the sheet code

Please Login or Register  to view this content.