Combine Multiple Criteria Using Filter and Array

Question

I'm in the process to make a sheet for workorder, but i had a problem when i need to combine multiple row to 1 cell. i already can do it using copy paste to all the cells in 1 column, but can i do this to array?

This my sheet: https://docs.google.com/spreadsheets/d/1ZcqfDJYEINBimmXEM3h3hl9qTdUBrAKS3IBqazJfQyE/edit?usp=sharing

player0 · Accepted Answer · 2021-01-10 13:35:47Z

2

use:

=ARRAYFORMULA(IF(B3:B="";;REGEXREPLACE(C3:C&CHAR(10)&D3:D; "^\n"; )))

edited Jan 10, 2021 at 13:35

answered Jan 10, 2021 at 12:52

player0

131k14 gold badges91 silver badges149 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Combine Multiple Criteria Using Filter and Array

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related