concating data in top most cell for every range

[mijaz]

I have data in two columns i.e A and B. A column has numerics and B column has alphabetical values against them. But each numeric in column has more than one alphabetical value against it in column B e.g:

Column A Column B
cell A1:123 Cell B1: a
Cell B2: b
Cell B3: c
cell A2:124 Cell B4: a
Cell B5:c
cell A3:128 Cell B6: 1
Cell B7: 4

There are three values against "123" of cell A1 in B1, B2 and B3. Similarly, Cell A2 and A3 have two values each in column B.

I want to concatenate all values belonging to column A's specific numerics in one cell in column B. I mean B1 to B3 should be top concatenated.

Thanks in Advance,

Regards,

 

[jim may]

This is what you have layed out, according to your verbage. This isn't going to be easy... hummmmmmmmmmm

Excel Workbook
	A	B
1	123	a
2	124	b
3	128	c
4		a
5		c
6		1
7		4
Sheet1

Excel 2007