0

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

Sample Data

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,

Output value

Zoe
  • 27,060
  • 21
  • 118
  • 148
  • see: https://stackoverflow.com/questions/62698523/need-help-getting-multiple-values-in-single-cell-with-condition-to-be-satisfied – Scott Craner Jul 03 '20 at 15:39
  • And: https://stackoverflow.com/questions/56858571/merge-values-of-column-b-based-on-common-values-on-column-a – Scott Craner Jul 03 '20 at 15:42

0 Answers0