Data Analysis

Reshape A Grid With The TOCOL And TOROW Functions In Excel Most functions want a list, not a block. TOCOL and TOROW flatten a range into one line, but they read across each row by default, which is rarely… August 28, 2026 · Excel Formulas Replace Fill Down With The ARRAYFORMULA Function In Google Sheets One formula that calculates a whole column, including the rows that do not exist yet. This article replaces a filled-down column with a single array formula, covers the… August 15, 2026 · Google Sheets Formulas Write SQL In A Cell With The Google Sheets QUERY Function Filter, group, sort and total a Google Sheet from inside a single cell, using the same select and where clauses you would write against a database. This article… August 13, 2026 · Google Sheets Formulas