Joining two columns together for rows that match criteria

Cyr

Hello,

I have a sheet with many columns from which I want to pull [Data]2 and [Data]20, in this format: "Data2 (Data20), Data2 (Data20),..." from another sheet.

So far we have

=IF(ISBLANK([Source1]@row), "", JOIN(COLLECT({Data2}, {Data5}, CONTAINS([Source1]@row, @cell), {Major/Minor}, "Major"), ", "))

And get

Data2, Data2, Data2, ...

but we have no way to add the second part. Any solutions?

Appreciate any help! We are stumped on our end :)

Paul Newcome

You would need to combine them in each row on the individual sheets and then pull them into this sheet.