Insert values from multiple rows based on value in one column

pachmarhi · #1 07-18-2014, 09:50 AM

I have a list of people with house numbers, names and email addresses.

House| Name | email
W2 | Fred | abc@zzz.com
W2 | Adil | xyz@zzz.com
W2 | Mark | cdf@zzz.com
W2 | Anya | 3456@zzz.com
E4 | Sai | tecx@zzz.com
E4 | Guru | gfyj@zzz.com
E4 | Mary | wedr@zzz.com

I need to be able to create an additional column that lists names and email addresses of everyone in the same house. So e.g., for each row in house W2 it will list Fred, Adil, Mark and Anya. etc.

Any suggestions on how to do this. I have about 2000 rows and about 280 different houses.

Thanks

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Referencing rows of a table at a bookmarked location based on the value of a column	jpb103	Word VBA	11	05-22-2014 08:33 AM
Mouseover cell to indicate mouse pointer location based on Specific Row/Column values	bolandk	Excel	1	05-15-2014 08:22 AM
Need help on duplicates in column; deciding which to keep based on other column	nwcf	Excel	3	01-31-2014 09:43 AM
transpose values based on mulitple criteria	mlttkw	Excel	1	12-06-2013 02:00 AM
change values based on cell	ubns	Excel	1	05-21-2012 06:28 PM