0

I have an excel with values like below

enter image description here

The last Column alone has different values, They are in fact url of images.

How do I merge those values with commas or any separator?

braX
  • 11,506
  • 5
  • 20
  • 33
hindisong.cc
  • 97
  • 7
  • Could you copy/paste to word document, use the find and replace function to replace "https" with "; https" and then replace all? Once that happens, merge the cells and copy/paste back into excel? – Tianna Wrona Feb 25 '21 at 16:49
  • here is a good starting point: https://stackoverflow.com/questions/56858571/merge-values-of-column-b-based-on-common-values-on-column-a – Scott Craner Feb 25 '21 at 16:50
  • You can use Power Query. `GroupBy` the identical columns with `Operation: All Rows`. Then turn the grouped table into a list and extract the list with your desired separator. – Ron Rosenfeld Feb 26 '21 at 01:06
  • @ScottCraner I followed the steps in that answer, It doesn't work. I pasted the code `=IF(MATCH(A1,A:A,0)=ROW(A1),TEXTJOINIFS(E:E,", ",A:A,A1),"")` in the formula, and pasted the UDF into the macro. All am seeing Invalid Outside Procedure. Am using MS Office Professional Plus 2019. – hindisong.cc Feb 26 '21 at 07:39

1 Answers1

2

If you have access to FILTER, UNIQUE, and TEXTJOIN:

  1. G1 = UNIQUE(A1:D6)
  2. K1 = TEXTJOIN(", ",TRUE,FILTER(E1:E6,(A1:A6=G1)*(B1:B6=H1)*(C1:C6=I1)*(D1:D6=J1)))

enter image description here

urdearboy
  • 14,439
  • 5
  • 28
  • 58