I have a excel sheet which is sorted for Column 2(colm2) as shown in attached example.

It has duplicate cell values. Each duplicate cell has associated data. Now I want to find and match duplicate from column2 and merge data in following way,

I have a excel sheet which is sorted for Column 2(colm2) as shown in attached example.

It has duplicate cell values. Each duplicate cell has associated data. Now I want to find and match duplicate from column2 and merge data in following way,
