Multiple row contents into one row

[assainar kutty]

Hi,
I have a list of Catalog which contains more than 5000 numbered items as shown below sample. Colum A is Material number and Colum B is the detailed description of material . The description in Colum B is written in one or more rows. I,e 90100100(A2) having 3 rows(B2:B4), the next material number (A5) having 4 rows(B5:B8)….. I need to apply a formula that Contents of all the rows of item A2 in one row in column C2 and contents of the rows of item A5 in one row in column C5…….till end of the list. Each row to be separated with a comma(,).

Is there any formula or macro to fill for all the materials?

Material Detailed Description

90100100 RANGE 3 CONDUCTOR BOX X PIN
309.72 LB/FT (1.000" WT)
XLF CONNECTIONS
90100101 COND,30,310#,X52,XLF B,W/FS,R3
RANGE 3 CONDUCTOR BOX X FLOAT SHOE
309.72 LB/FT (1.000" WT)
XLF BOX X WELD ON FLOAT SHOE
90100102 RANGE 3 CONDUCTOR BOX X PIN WITH STABILIZER FINS TYPE ?
309.72 LB/FT (1.000" WT)
XLF CONNECTIONS
W/STABILIZER FINS WELDED ON
STARTER HEAD

90100103 RANGE 3 CONDUCTOR BOX X PIN WITH CAMERON LOAD RING
309.72 LB/FT (1.000" WT)
XLF CONNECTIONS
90100104 RANGE 3 CASING BOX X PIN
87.5 LB/FT (0.435" WT)
BIG OMEGA CONNECTIONS (WITH K-55 COUPLING)


With many thanks

Kutty