find duplicates sort then next colums data combined

Hi All,


I need to give the sequence to column B based on text value then next column data in one cell. Suppose when sort column B contain 3 rows of one similer text the formula or code concate next three cells in one the workook is attached.

Thanks
frs

Hello there,

This should work for you

Please Login or Register  to view this content.

To use this code

1.Press Alt+F8 on your keyboard
2.Clear the macro name box and type SortAndCombine in the blank box provided
3.Select the Create option
4.In between the Sub SortAndCombine() and End Sub copy and paste one of the options I have provided above.
5.Exit out of the Visual Basic Window
6.Press Alt+F8 again and this time select the SortAndCombine macro
7.Select Run

Try the attached

Please Login or Register  to view this content.