Spreadsheet: 356643d1415173194-concatenate-as-long-there-are-values-in-the-next-cells-help
Sheet: Sample

 |  |  | Client 1 | Client 1 | Client 1 | Client 1 | Client 1 | Client 1 | Client 1 | Client 1 | Client 1 | Client 1 | Client 1 | Client 1 | Client 1 | Client 1 | Client 1 | Client 2 | Client 3 | Client 4 | Client 5 | Client 6 | Client 7 | Client 8
 | Client Name 2 |  | Client Name 1 | Client Name 1 | Client Name 1 | Client Name 1 | Client Name 1 | Client Name 1 | Client Name 1 | Client Name 1 | Client Name 1 | Client Name 1 | Client Name 1 | Client Name 1 | Client Name 1 | Client Name 1 | Client Name 1 | Client Name 2 | Client Name 3 | Client Name 4 | Client Name 5 | Client Name 6 | Client Name 7 | Client Name 8
 | Concatenated CR ID's |  | [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE] | [PHONE], [PHONE], [PHONE], [PHONE] | [PHONE], [PHONE], [PHONE], [PHONE] | [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE] | [PHONE], [PHONE] | [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE] | [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE] | [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE] | [PHONE] | [PHONE], [PHONE] | [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE] | [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE] | [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE] | [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE] | [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE] | [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE] | [PHONE], [PHONE] | [PHONE], [PHONE], [PHONE] | [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE] | [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE] | [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE] | [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE], [PHONE]
 | Client Name 3 |  | [PHONE] | [PHONE] | [PHONE] | [PHONE] | [PHONE] | [PHONE] | [PHONE] | [PHONE] | [PHONE] | [PHONE] | [PHONE] | [PHONE] | [PHONE] | [PHONE] | [PHONE] | [PHONE] | [PHONE] | [PHONE] | [PHONE] | [PHONE] | [PHONE] | [PHONE]
 | CR ID's |  | [PHONE] | [PHONE] | [PHONE] | [PHONE] | [PHONE] | [PHONE] | [PHONE] | [PHONE] | [PHONE] | [PHONE] | [PHONE] | [PHONE] | [PHONE] | [PHONE] | [PHONE] | [PHONE] | [PHONE] | [PHONE] | [PHONE] | [PHONE] | [PHONE] | [PHONE]
 |  |  | [PHONE] | [PHONE] | [PHONE] | [PHONE] | [PHONE] | [PHONE] | [PHONE] | [PHONE] |  | [PHONE] | [PHONE] | [PHONE] | [PHONE] | [PHONE] | [PHONE] | [PHONE] | [PHONE] | [PHONE] | [PHONE] | [PHONE] | [PHONE] | [PHONE]
 |  |  | [PHONE] | [PHONE] | [PHONE] | [PHONE] |  | [PHONE] | [PHONE] | [PHONE] |  |  | [PHONE] | [PHONE] | [PHONE] | [PHONE] | [PHONE] | [PHONE] |  | [PHONE] | [PHONE] | [PHONE] | [PHONE] | [PHONE]
 |  |  | [PHONE] | [PHONE] | [PHONE] | [PHONE] |  | [PHONE] | [PHONE] | [PHONE] |  |  | [PHONE] | [PHONE] | [PHONE] | [PHONE] | [PHONE] | [PHONE] |  |  | [PHONE] | [PHONE] | [PHONE] | [PHONE]
 |  |  | [PHONE] |  |  | [PHONE] |  | [PHONE] | [PHONE] | [PHONE] |  |  | [PHONE] | [PHONE] | [PHONE] | [PHONE] | [PHONE] | [PHONE] |  |  | [PHONE] | [PHONE] | [PHONE] | [PHONE]
 |  |  | [PHONE] |  |  | [PHONE] |  | [PHONE] | [PHONE] | [PHONE] |  |  | [PHONE] | [PHONE] | [PHONE] | [PHONE] | [PHONE] | [PHONE] |  |  | [PHONE] | [PHONE] | [PHONE] | [PHONE]
 |  |  | [PHONE] |  |  |  |  |  | [PHONE] | [PHONE] |  |  | [PHONE] | [PHONE] |  | [PHONE] | [PHONE] |  |  |  | [PHONE] | [PHONE] | [PHONE] | [PHONE]
 |  |  | [PHONE] |  |  |  |  |  | [PHONE] | [PHONE] |  |  | [PHONE] |  |  | [PHONE] | [PHONE] |  |  |  | [PHONE] | [PHONE] | [PHONE] | [PHONE]
 |  |  | [PHONE] |  |  |  |  |  | [PHONE] | [PHONE] |  |  | [PHONE] |  |  | [PHONE] | [PHONE] |  |  |  | [PHONE] | [PHONE] | [PHONE] | [PHONE]
 |  |  | [PHONE] |  |  |  |  |  | [PHONE] | [PHONE] |  |  | [PHONE] |  |  | [PHONE] | [PHONE] |  |  |  |  | [PHONE] | [PHONE] | [PHONE]
 |  |  |  |  |  |  |  |  | [PHONE] | [PHONE] |  |  | [PHONE] |  |  | [PHONE] | [PHONE] |  |  |  |  |  | [PHONE] | [PHONE]
 |  |  |  |  |  |  |  |  | [PHONE] | [PHONE] |  |  | [PHONE] |  |  | [PHONE] | [PHONE] |  |  |  |  |  | [PHONE] | [PHONE]
 |  |  |  |  |  |  |  |  | [PHONE] | [PHONE] |  |  | [PHONE] |  |  | [PHONE] | [PHONE] |  |  |  |  |  | [PHONE] | [PHONE]
 |  |  |  |  |  |  |  |  | [PHONE] | [PHONE] |  |  | [PHONE] |  |  | [PHONE] | [PHONE] |  |  |  |  |  | [PHONE] | [PHONE]
 |  |  |  |  |  |  |  |  | [PHONE] | [PHONE] |  |  |  |  |  | [PHONE] | [PHONE] |  |  |  |  |  | [PHONE] | [PHONE]
 |  |  |  |  |  |  |  |  | [PHONE] | [PHONE] |  |  |  |  |  | [PHONE] | [PHONE] |  |  |  |  |  | [PHONE] | [PHONE]
 |  |  |  |  |  |  |  |  |  | [PHONE] |  |  |  |  |  | [PHONE] | [PHONE] |  |  |  |  |  | [PHONE] | [PHONE]
 |  |  |  |  |  |  |  |  |  | [PHONE] |  |  |  |  |  | [PHONE] | [PHONE] |  |  |  |  |  | [PHONE] | [PHONE]
 |  |  |  |  |  |  |  |  |  | [PHONE] |  |  |  |  |  | [PHONE] | [PHONE] |  |  |  |  |  | [PHONE] | [PHONE]
 |  |  |  |  |  |  |  |  |  | [PHONE] |  |  |  |  |  | [PHONE] | [PHONE] |  |  |  |  |  | [PHONE] | [PHONE]
 |  |  |  |  |  |  |  |  |  | [PHONE] |  |  |  |  |  | [PHONE] |  |  |  |  |  |  | [PHONE] | [PHONE]
 |  |  |  |  |  |  |  |  |  | [PHONE] |  |  |  |  |  | [PHONE] |  |  |  |  |  |  | [PHONE] | [PHONE]
 |  |  |  |  |  |  |  |  |  | [PHONE] |  |  |  |  |  | [PHONE] |  |  |  |  |  |  | [PHONE] | [PHONE]
 |  |  |  |  |  |  |  |  |  | [PHONE] |  |  |  |  |  | [PHONE] |  |  |  |  |  |  | [PHONE] | [PHONE]
 |  |  |  |  |  |  |  |  |  | [PHONE] |  |  |  |  |  | [PHONE] |  |  |  |  |  |  | [PHONE] | [PHONE]
 |  |  |  |  |  |  |  |  |  | [PHONE] |  |  |  |  |  | [PHONE] |  |  |  |  |  |  | [PHONE] | [PHONE]
 |  |  |  |  |  |  |  |  |  | [PHONE] |  |  |  |  |  | [PHONE] |  |  |  |  |  |  | [PHONE] | [PHONE]
 |  |  |  |  |  |  |  |  |  | [PHONE] |  |  |  |  |  | [PHONE] |  |  |  |  |  |  | [PHONE] | [PHONE]
 |  |  |  |  |  |  |  |  |  | [PHONE] |  |  |  |  |  | [PHONE] |  |  |  |  |  |  | [PHONE] | [PHONE]
 |  |  |  |  |  |  |  |  |  | [PHONE] |  |  |  |  |  | [PHONE] |  |  |  |  |  |  | [PHONE]
 |  |  |  |  |  |  |  |  |  | [PHONE] |  |  |  |  |  | [PHONE] |  |  |  |  |  |  | [PHONE]
 |  |  |  |  |  |  |  |  |  | [PHONE] |  |  |  |  |  | [PHONE] |  |  |  |  |  |  | [PHONE]
 |  |  |  |  |  |  |  |  |  | [PHONE] |  |  |  |  |  | [PHONE]
 |  |  |  |  |  |  |  |  |  | [PHONE] |  |  |  |  |  | [PHONE]
 |  |  |  |  |  |  |  |  |  | [PHONE] |  |  |  |  |  | [PHONE]
 |  |  |  |  |  |  |  |  |  | [PHONE] |  |  |  |  |  | [PHONE]
 |  |  |  |  |  |  |  |  |  | [PHONE] |  |  |  |  |  | [PHONE]