Erase / Filter rows with info from the ones in blank

Question

I have this data in a Google Sheet, basically is a dynamic 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 recommendations please! (The only information not dynamic is the blue rows)

player0 · Accepted Answer · 2022-04-19T09:53:57.053

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))<>"")

edited Apr 19 '22 at 09:53

answered Apr 18 '22 at 19:38

player0

124,011
12
67
124

1

Thanks that is the solution I was looking for – Apr 18 '22 at 21:13
I have a doubt this only works with horizontal ranges right? – Apr 19 '22 at 03:05
1

@Eduardomaker yes. answer updated – player0 Apr 19 '22 at 09:54

Erase / Filter rows with info from the ones in blank

1 Answers1