Transpose 2 column [Key, values] list to mulit column [unique Key, Value1, value2, value3, ......] list

[ganesannv]

I have the following data in Sheet 1:

Code Values
1001 2101
1001 5205
1001 2605
1001 9285
2604 4256
2604 7458
2604 3555

Required result:

Code Value1 Value2 Value3 Value4
1001 2101 5205 2605 9285
2604 4256 7458 3555

Can get a formula to get the result.