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,