Concatenate In Excel with Match

[niladrib]

Hi All,

In excel i have the data like below(Column A and B)

[TABLE="width: 500"]
<tbody>[TR]
[TD]A1[/TD]
[TD]BALOD[/TD]
[/TR]
[TR]
[TD]A1[/TD]
[TD]DONDI[/TD]
[/TR]
[TR]
[TD]A1[/TD]
[TD]DONDI Luhara[/TD]
[/TR]
[TR]
[TD]B1[/TD]
[TD]BCSD[/TD]
[/TR]
[TR]
[TD]B1[/TD]
[TD]VIVEK NAVEEN[/TD]
[/TR]
[TR]
[TD]C1[/TD]
[TD]GFTKJ[/TD]
[/TR]
</tbody>[/TABLE]


I have the Unique name like A1, B1 and C1 in another cloumn J. I want to add all the A1, B1 and C1 and the output should look like below. there is no fixed order...A1 can be 3 times, 4 times, 5 times , B1 can be 1 time, 2 times and so on...

[TABLE="width: 500"]
<tbody>[TR]
[TD]A1[/TD]
[TD]BALOD;DONDI;DONDI Luhara[/TD]
[/TR]
[TR]
[TD]B1[/TD]
[TD]BCSD;VIVEK NAVEEN[/TD]
[/TR]
[TR]
[TD]C1[/TD]
[TD]GFTKJ[/TD]
[/TR]
</tbody>[/TABLE]

Is it possible to do this using formulas ? I do not want to use macro or VBA. Please help!!

Regards,
Niladri

****** id="cke_pastebin" style="position: absolute; top: 337px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">[TABLE="width: 500"]
<tbody>[TR]
[TD]GFTKJ[/TD]
[/TR]
</tbody>[/TABLE]
</body>