CODEWITHSUNDEEP
excelvbaexcel-formula
hindisong.cc
hindisong.cc

Reputation: 101

How to merge two rows in a which has same values in other columns in Excel?

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?

Upvotes: 0

Views: 897

Answers (1)

urdearboy
urdearboy

Reputation: 14580

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

Upvotes: 2

Related Questions