Debug — BYROW Returns Wrong Array Shape

An ops analyst's "row totals" formula is spilling horizontally instead of down a column. Their formula in G2 was:

=BYCOL(B2:F11, LAMBDA(col, SUM(col)))

It returns a 1×5 array (one total per quarter, spilled across G2:K2) — but they wanted a 10×1 array (one total per product, spilled down G2:G11). Quarter totals across, not product totals down.

The fix: swap BYCOL for BYROW. BYROW iterates each row of the source, applies the LAMBDA, and stacks results vertically. BYCOL does the same column-wise.

Columns A–F contain ProductID and Q1–Q5 unit sales for 10 products.

Your task:

1. In G2, write the corrected BYROW formula. The result spills down G2:G11 — don't drag.
2. The LAMBDA receives one row at a time as a 1×5 array; SUM(row) collapses it to a single total.

The spill range (G2:G11) must be empty before the formula runs; any content in G3:G11 produces #SPILL!.

Graded cells: G2 (P-001 → 1000), G5 (P-004 → 200), G9 (P-008 → 2000).