Conditional Transpose/Concatenation?

[slavrenz]

Say I've got the following user data laid out in three columns:

FirstName LastName Address


In some cases, there can be multiple rows with the same "Address" value (i.e., multiple people live at the same address). I would like to set up my data so that each row has a unique address value, concatenating/transposing the data as necessary. For example:

FirstName1 LastName1 FirstName2 LastName2 Address


There are never more than 2 names associated with 1 address, so my final altered data will have 5 columns. I was thinking there might be a way to do this with the INDEX(MATCH()) functions, but that's about as far as I've gotten successfully. Also, that doesn't solve the issue of needing to transpose the data from certain rows with (e.g., FirstName2 and LastName2)

Does anyone know of a good way to approach this?

[Special-K]

Prob VBA best