Merger Multiple rows and columns to a single value

[Srinath_enigma]

HI,

I am looking for merging the data as below.
Column 1 Column 2
Row1 A Test
Row2 A Pass
Row3 S New
Row4 S Old
Row5 S Old

I'm looking to have the values of A in a single row and single column and similar way for S. The duplicate entries old needs to be merged to single and the column need to have single entry and the relevant multiple values needs to merged to gether.
Column 1 Column 2
Row1 A Test; Pass
Row2 S New; Old

Could assist on this please?

Thanks In advance

Regards
Srinath

[e.isayev]

Cell c3
=index(if(a1=$a$1:$a$5,$b$1:$b$5,""),match(a1,$a$1:$a$5,0))&"; "&index(if(a1=$a$1:$a$5,$b$1:$b$5,""),match(a1,$a$1:$a$5,0)+1)