Spreadsheet: 847019d1698133352-build-array-with-multiple-filters-20231024
Sheet: Result

 | List with new data
 | Room12
 | Room20
 | Room102
 | Room85
 | Room65
 | Result
 | A | Room12 |  |  | Room12
 | B | Room12 |  | E | Room20
 | … | … |  | E | Room20
 |  |  |  | E | Room20
 |  |  |  | F | Room20
 |  |  |  | G | Room12
 |  |  |  | H | Room65
 |  |  |  | H | Room20
 |  |  |  | H | Room20
 |  |  |  | H | Room85
 |  |  |  | H | Room12
 |  |  |  | H | Room102
 |  |  |  | H | Room102
 |  |  |  | H | Room20
 |  |  |  | H | Room20
 |  |  |  | H | Room20
 |  |  |  | H | Room20
 |  |  |  | H | Room20
 |  |  |  | H | Room20
 |  |  |  | H | Room20
 |  |  |  | H | Room12
 |  |  |  | H | Room65
 |  |  |  | H | Room65
 |  |  |  | H | Room20
 |  |  |  | H | Room20
 |  |  |  | H | Room85
 |  |  |  | H | Room12
 |  |  |  | H | Room102
 |  |  |  | H | Room102
 |  |  |  | H | Room20
 |  |  |  | H | Room20
 |  |  |  | H | Room20
 |  |  |  | H | Room20
 |  |  |  | H | Room20
 |  |  |  | H | Room20
 |  |  |  | H | Room20
 |  |  |  | H | Room12
 |  |  |  | H | Room65
 |  |  |  | H | Room85
 |  |  |  | H | Room20
 |  |  |  | H | Room20
 |  |  |  | H | Room20
 |  |  |  | H | Room20
 |  |  |  | H | Room20
 |  |  |  | H | Room20
 |  |  |  | H | Room20
 |  |  |  | H | Room20
 |  |  |  | H | Room20
 |  |  |  | H | Room20
 |  |  |  | H | Room20
 |  |  |  | H | Room20
 |  |  |  | H | Room85
 |  |  |  | H | Room20
 |  |  |  | H | Room20
 |  |  |  | H | Room20
 |  |  |  | H | Room20
 |  |  |  | H | Room20
 |  |  |  | H | Room20
 |  |  |  | H | Room20
 |  |  |  | H | Room20
 |  |  |  | H | Room20
 |  |  |  | H | Room20
 |  |  |  | H | Room20
 |  |  |  | H | Room20
 |  |  |  | K | Room102
 |  |  |  | L | Room102
 |  |  |  | L | Room20
 |  |  |  | L | Room20
 |  |  |  | L | Room20
 |  |  |  | L | Room20
 |  |  |  | L | Room20
 |  |  |  | M | Room20
 |  |  |  | M | Room102
 |  |  |  | M | Room20
 |  |  |  | M | Room20
 |  |  |  | M | Room20
 |  |  |  | M | Room20
 |  |  |  | M | Room20
 |  |  |  | M | Room20
 |  |  |  | M | Room20
 |  |  |  | N | Room12
 |  |  |  | O | Room12
 |  |  |  | O | Room12
 |  |  |  | O | Room12
 |  |  |  | O | Room12
 |  |  |  | O | Room12
 |  |  |  | G | Room20
 |  |  |  | P | Room20
 |  |  |  | P | Room20
 |  |  |  | S | Room102
 |  |  |  | S | Room20
 |  |  |  | S | Room20
 |  |  |  | S | Room20
 |  |  |  | S | Room20
 |  |  |  | S | Room12
 |  |  |  | S | Room12
 |  |  |  | T | Room65
 |  |  |  | T | Room20
 |  |  |  | T | Room20
 |  |  |  | T | Room12
 |  |  |  | T | Room85
 |  |  |  | T | Room20
 |  |  |  | T | Room20
 |  |  |  | T | Room12
 |  |  |  | T | Room12
 |  |  |  | T | Room20
 |  |  |  | T | Room20
 |  |  |  | T | Room12
 |  |  |  | T | Room85
 |  |  |  | T | Room20
 |  |  |  | T | Room20
 |  |  |  | T | Room20
 |  |  |  | T | Room65
 |  |  |  | T | Room65
 |  |  |  | T | Room12
 |  |  |  | T | Room20
 |  |  |  | T | Room20
 |  |  |  | T | Room20
 |  |  |  | T | Room20
 |  |  |  | T | Room20
 |  |  |  | T | Room20
 |  |  |  | T | Room65
 |  |  |  | T | Room20
 |  |  |  | T | Room20
 |  |  |  | T | Room20
 |  |  |  | T | Room20
 |  |  |  | T | Room12
 |  |  |  | T | Room102
 |  |  |  | T | Room102
 |  |  |  | T | Room102
 |  |  |  | T | Room102
 |  |  |  | T | Room12
 |  |  |  | T | Room12
 |  |  |  | T | Room65
 |  |  |  | T | Room65
 |  |  |  | T | Room20
 |  |  |  | T | Room20
 |  |  |  | T | Room20
 |  |  |  | T | Room20
 |  |  |  | T | Room20
 |  |  |  | T | Room20
 |  |  |  | T | Room20
 |  |  |  | T | Room20
 |  |  |  | T | Room20
 |  |  |  | T | Room20
 |  |  |  | T | Room20
 |  |  |  | T | Room20
 |  |  |  | T | Room20
 |  |  |  | T | Room20
 |  |  |  | T | Room20
 |  |  |  | T | Room20
 |  |  |  | T | Room20
 |  |  |  | T | Room20
 |  |  |  | T | Room20
 |  |  |  | T | Room20
 |  |  |  | T | Room20
 |  |  |  | T | Room20
 |  |  |  | T | Room65
 |  |  |  | T | Room20
 |  |  |  | T | Room20
 |  |  |  | T | Room20
 |  |  |  | T | Room20
 |  |  |  | T | Room65
 |  |  |  | T | Room20
 |  |  |  | U | Room65
 |  |  |  | U | Room102
 |  |  |  | U | Room20
 |  |  |  | U | Room20
 |  |  |  | A | Room20
 |  |  |  | A | Room20
 |  |  |  | A | Room20
 |  |  |  | A | Room102
 |  |  |  | A | Room20
 |  |  |  | A | Room20
 |  |  |  | A | Room20