Concatenate In Excel with Match

[niladrib]

Hi All,

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

A1	BALOD
A1	DONDI
A1	DONDI Luhara
B1	BCSD
B1	VIVEK NAVEEN
C1	GFTKJ

<tbody>
</tbody>

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...

A1	BALOD;DONDI;DONDI Luhara
B1	BCSD;VIVEK NAVEEN
C1	GFTKJ

<tbody>
</tbody>

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;">

GFTKJ

<tbody>
</tbody>

</body>