Help Using JOIN(COLLECT

Doris F

Hello,

I have used the following formula to collect values from a source sheet into a target sheet:

=JOIN(COLLECT({Deviation#}, {Batch}, Batch@row), CHAR(10)) + CHAR(10) + JOIN(COLLECT({Classification}, {Batch}, Batch@row), CHAR(10)) + CHAR(10) + JOIN(COLLECT({Status}, {Batch}, Batch@row), CHAR(10))

Resulting Field has: 648659 Minor Open

1. What do I do if I prefer to use a delimiter instead of the CHAR(10)?
2. I have a situation where the source sheet has multiple rows from which results are being returned into the resulting filed, yielding: 648659 123456 Minor Major Open Closed. I would prefer the sequence to read:

648659, Minor, Open

123456, Major, Closed

Is this possible?

THANKS!!!

Paul Newcome

My suggestion would be to create a helper column on the source sheet where you join the strings together on a row by row basis using the commas and then pull from this helper column into the other sheet.

Paul Newcome

My suggestion would be to create a helper column on the source sheet where you join the strings together on a row by row basis using the commas and then pull from this helper column into the other sheet.

Doris F

@Paul Newcome

THANK YOU!!!!

Paul Newcome

Happy to help. 👍️