9.8 VSTACK and HSTACK

By Ravindra Bagale Last updated: 25 September 2026

Microsoft 365 / Excel 2024. =VSTACK(array1, array2, …) stacks vertically (append); =HSTACK(array1, array2, …) places side by side.

Worked example – append Blinkit and Amazon Now sheets without copy-paste.

=VSTACK(tblBlinkit, tblAmazonNow)

With a header row and removing blank rows:

=LET(all, VSTACK(tblBlinkit, tblAmazonNow),
     VSTACK(tblBlinkit[#Headers], FILTER(all, CHOOSECOLS(all,1)<>"")))

Build a report block: =HSTACK(UNIQUE(tblMini[Platform]), SUMIFS(tblMini[Amount], tblMini[Platform], UNIQUE(tblMini[Platform]))) → Blinkit 2,333, Amazon Now 537.

Ravindra Bagale's Tip

VSTACK karaychya donhi tables madhe columns chi order same pahije – nahitar Amazon Now cha City column Blinkit chya Area khali yeto, aani khup students la te kalat pan nahi. Aadhi headers compare kara. Motha, roj vadhnara data asel tar Power Query Append (Module 10.4) jast surakshit aahe.

Practice task

Stack three monthly order Tables with VSTACK, sort the result by date and count the rows. Use HSTACK to show City, Sales and Orders side by side.