'Erase / Filter rows with info from the ones in blank
Hi everyone I have this data in a Google Sheet, basically is a dinamyc table that will have more information or could change in a future with more or less rows, in the same image at the right you will see what I need, I was thinking about use BLANK but is giving me some errors, also I tried with transposeFilter but same problem. Some help or recomendations please! (The only information not dinamyc is the blue rows)
Solution 1:[1]
try for horizontal erase:
=FILTER(A:D; TRIM(FLATTEN(QUERY(TRANSPOSE(A:D);;9^9)))<>"")
or vertical erase:
=FILTER(A:D; TRIM(QUERY(A:D;;9^9))<>"")
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 |