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:

 

Name	Contact	#1	#2	#3	#4	#5
Aker	Wik	111	555	222
Aker	Wik	222	555
Aker	Wik	333	555	111
Aker	Wik	444	555
Aker	Wik	555	111
Law Firm	Harold	777

 

I need to consolidate the # fields under a unique name. So I would end up with something like this....

 

Name	Contact	#1	#2	#3	#4	#5
Aker	Wik	111	222	333	444	555
Law Firm	Harold	777

 

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