Reshape Data with Formulas: Unpivot, Stack, Wrap & Merge (Power-Query-Style)
Pick and reorder columns with CHOOSECOLS and XMATCH, append exports with VSTACK and a source column, pad uneven lists with EXPAND, unpivot wide tables with TOCOL, pivot back with a two-key XLOOKUP and PIVOTBY, rebuild one-field-per-line files with WRAPROWS and trim report headers with TAKE and DROP: 8 hands-on labs at one rental company, graded instantly.
The first 2 lessons are free — no account needed.
Lessons
- Pick and Reorder Columns and Rows: CHOOSECOLS and CHOOSEROWSFree
- Append Tables with VSTACK: One Header, a Source Column and No Empty RowsFree
- Join Columns with HSTACK and Fill the Gaps with EXPAND Pro
- Unpivot Wide Tables into Long Lists: TOCOL, TOROW and INDEX/SEQUENCE Pro
- Pivot Long Lists into Grids: Two-Key XLOOKUP, PIVOTBY and FILTER Pro
- WRAPROWS and WRAPCOLS: Rebuild Records and Lay Out Report Grids Pro
- TAKE and DROP: Strip Report Headers and Footers, Last-N and Top-N Pro
- Capstone: Merge Three Different Exports into One Clean Table Pro