How to Remove Blank Rows in Excel Safely

I use Microsoft 365 Excel. Source sheet Import has headers in A1:D1 and data A2:D10.

Row 2 T-201 | Ana | 3 | Ready
Row 3 [truly empty across A:D]
Row 4 T-202 | [truly empty B4] | 0 | Hold
Row 5 every A:D cell contains ="" and displays blank
Row 6 T-203 | Bo | [truly empty C6:D6]
Row 7 [truly empty A7:C7] | Comment in D7
Row 8 T-204 | Cy | 5 | Done
Row 9 every A:D cell contains ="" and displays blank
Row 10 T-205 | Di | 2 | [truly empty D10]

On separate sheet Clean, create a non-destructive output that includes headers; excludes rows 3, 5, and 9; retains partial rows 4, 6, 7, 10; retains zero in C4; preserves order; and updates without changing Import.

Use exactly this in Clean!A1:
=LET(data,Import!A2:D10,header,Import!A1:D1,keep,BYROW(data,LAMBDA(r,SUM(--(LEN(r)>0))>0)),IF(SUM(--keep)=0,header,VSTACK(header,FILTER(data,keep))))

Expected output: header plus T-201 Ana 3 Ready; T-202 [blank] 0 Hold; T-203 Bo [blank, blank]; [blank, blank, blank, Comment]; T-204 Cy 5 Done; T-205 Di 2 [blank].

Explain why LEN treats true blanks and formula "" results as zero-length while LEN(0)>0. Whitespace-only values count as populated and remain. Enter the formula in an empty area with room to spill. Require a current Microsoft 365 build or Excel 2024 with LET, FILTER, BYROW, VSTACK, and dynamic arrays on Windows/Mac; older builds without these functions cannot use it as written.

I have Excel Table tblTransactions on sheet Source with six rows:

1 TX-301 | Sales | 125.50 | Posted
2 [null] | [null] | [null] | [null]
3 TX-302 | Refunds | 0 | Review
4 TX-303 | [null] | 42.00 | [null]
5 [null] | [null] | [null] | Imported note
6 [null] | [null] | [null] | [null]

Rows 2 and 6 are all null. Rows 3, 4, and 5 are partial or contain zero and must remain. There are no empty strings or whitespace-only values; the rule is specifically all four fields null.

Starting with Data → From Table/Range, create a refreshable Power Query result that removes only all-null rows, preserves source order, and loads to a separate new-worksheet table without changing tblTransactions.

After the source/type step, use exactly:
#"Removed Fully Null Rows" = Table.SelectRows(#"Changed Type", each List.NonNullCount(Record.FieldValues(_)) > 0)
and return it from the in line. Include the required comma after the preceding step and replace #"Changed Type" only if the actual previous step has another name.

Expected output: TX-301 Sales 125.50 Posted; TX-302 Refunds 0 Review; TX-303 [blank] 42.00 [blank]; [blank, blank, blank, Imported note].

Explain that empty strings and whitespace are non-null and would remain; hidden/filtered worksheet rows normally still belong to the source table/query. Load to a new worksheet and do not overwrite/delete the source. Require current Excel with Get & Transform/Power Query; Windows/Mac UI and older Mac availability vary, and Excel for the web may not offer the same authoring workflow.