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 stands with Ukraine
  • 25,310
  • 18
  • 114
  • 149
  • 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