CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formula
dion dion
dion dion

Reputation: 113

Combine Multiple Criteria Using Filter and Array

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?

enter image description here

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

Upvotes: 1

Views: 133

Answers (1)

player0
player0

Reputation: 1

use:

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

enter image description here

Upvotes: 2

Related Questions