Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 07-18-2014, 09:50 AM
pachmarhi pachmarhi is offline Windows 7 64bit Office 2007
Novice
 
Join Date: Feb 2009
Posts: 4
pachmarhi is on a distinguished road
Default Insert values from multiple rows based on value in one column

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
Reply With Quote
  #2  
Old 07-18-2014, 11:55 AM
charlesdh charlesdh is offline Windows 7 32bit Office 2010 32bit
Expert
 
Join Date: Apr 2014
Location: Mississippi
Posts: 361
charlesdh is on a distinguished road
Default

Hi,

You may need a "Macro" for this. If you can show the desired result.
It will help us to better understand your request.
Reply With Quote
  #3  
Old 07-18-2014, 02:37 PM
pachmarhi pachmarhi is offline Windows 7 64bit Office 2007
Novice
 
Join Date: Feb 2009
Posts: 4
pachmarhi is on a distinguished road
Default

Taking the example data above, I want to be able to generate the following:

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

If it is easier to list all housemates including the person in the row, that is fine too.
e.g.
W2 | Fred | abc@zzz.com | Fred, Adil, Mark, Anya
W2 | Adil | xyz@zzz.com | Fred, Adil, Mark, Anya
etc.

Ultimately I need to generate a mailmerge to email to let everyone know their housemates.

If it is easier to accomplish this using Access, that's fine with me too.

Thanks
Reply With Quote
  #4  
Old 07-18-2014, 09:57 PM
pachmarhi pachmarhi is offline Windows 7 64bit Office 2007
Novice
 
Join Date: Feb 2009
Posts: 4
pachmarhi is on a distinguished road
Default

I managed to do what I needed to using a crosstab query in MS Access. Thanks
Reply With Quote
Reply
Please reply to this thread with any new information or opinions.

Thread Tools
Display Modes


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


All times are GMT -7. The time now is 03:03 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft