How can I bring cell values from one sheet into another sheet "multiple values cell"?

Yars

Below is the source sheet

destination sheet

bisaacs

Hey @Yars,

You'll want to use JOIN & COLLECT to do this:

=JOIN(COLLECT(Fruit:Fruit, Type:Type, Column4@row), CHAR(10))

CHAR(10) as a delimiter splits each result into it's own selection.

Hope this helps!

bisaacs

Hey @Yars,

You'll want to use JOIN & COLLECT to do this:

=JOIN(COLLECT(Fruit:Fruit, Type:Type, Column4@row), CHAR(10))

CHAR(10) as a delimiter splits each result into it's own selection.

Hope this helps!

Yars

Yes, It worked. Thanks so much