Tuesday, October 22, 2013

yogi_Extract From Table Unique Names Contacts And Unique Sets Of Associated Numbers Arranged In Ascending Order

                                          Google Spreadsheet   Post  #1398
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Oct 22, 2013
question by Mallory Wiseman (http://productforums.google.com/forum/?zx=xmryj7p1rmod#!category-topic/docs/spreadsheets/Lmvk4pe3iLg)
merge/consolidate unique data into master row (???vlookup,unique,offset,match,index??not sure what to use)
My list looks similiar to this:
 
NameContact #1 #2#3#4#5
AkerWik111555222  
AkerWik222555   
AkerWik333555111  
AkerWik444555   
AkerWik555111   
Law Firm Harold777    
 
I need to consolidate the # fields under a unique name. So I would end up with something like this....
 
NameContact#1#2#3#4#5
AkerWik111222333444555
Law Firm Harold777    
 
A long time ago I had worked it out but i cant find the old spreadsheet and havent used google sheets in a while. if anyone can help that would be awesome!!
 
thanks!
------------------------------------------------------------------------------------------------------------------
here follows my convoluted solution