9.8 VSTACK and HSTACK
Microsoft 365 / Excel 2024. =VSTACK(array1, array2, …) stacks vertically (append); =HSTACK(array1, array2, …) places side by side.
Worked example – append FreshGo and MarketRush 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]))) → FreshGo 2,333, MarketRush 537.
Ravindra Bagale's Tip
Both tables you VSTACK must have the columns in the same order – otherwise MarketRush's City column lands under FreshGo's Area, and many students don't even notice. Compare the headers first. For big data that grows every day, Power Query Append (Module 10.4) is safer.
Ravindra Bagale's Tip – मराठी
VSTACK करायच्या दोन्ही tables मध्ये columns ची order same पाहिजे – नाहीतर MarketRush चा City column FreshGo च्या Area खाली येतो, आणि बऱ्याच students ना ते कळतही नाही. आधी headers compare करा. मोठा, रोज वाढणारा data असेल तर Power Query Append (Module 10.4) जास्त सुरक्षित आहे.
Ravindra Bagale's Tip – हिंदी
जिन दो tables को VSTACK करना है, उनमें columns का order same होना चाहिए – वरना MarketRush का City column FreshGo के Area के नीचे आ जाता है, और बहुत से students को पता भी नहीं चलता. पहले headers compare करो. बड़ा, रोज़ बढ़ने वाला data हो तो Power Query Append (Module 10.4) ज़्यादा सुरक्षित है.
Practice tasks (10+)
Try these on a blank sheet. Open a hint only if you are stuck. No quiz — just practice.
1. Rebuild the smallest example of vstack and hstack on a blank sheet for Summit Schools.
Hint: Use only the steps on this page. Keep numbers numeric.
2. Change one input for Aarti Kulkarni and confirm the result updates.
Hint: If the result is stuck, check absolute vs relative references.
3. Repeat the same steps with a £ or € value for Yuki Tanaka.
Hint: Formatting must not break SUM.
4. Write the result meaning in one plain sentence next to the cell.
Hint: Imagine explaining it to a new joiners.
5. Add a second row and fill the method down.
Hint: Double-click the fill handle if the pattern is consistent.
6. Break the example on purpose, then fix it using this lesson.
Hint: Common break: text instead of a number.
7. Apply vstack and hstack to a 5-row made-up Summit Schools table.
Hint: Keep column headers clear.
8. Check your answer with a simple total or COUNT.
Hint: A wrong total usually means a format or key mismatch.
9. Swap ₹ and $ on one column and re-check totals.
Hint: Stored values stay the same; only the display changes.
10. List two mistakes beginners make with vstack and hstack.
Hint: Look back at the tip box on this page.
11. Teach the steps out loud in under one minute.
Hint: Why → What → How.
12. Save the sheet as SummitSchoo_practice.xlsx.
Hint: Use a clear file name for class.
Quick revision cards
Three standalone cards. Each one explains the idea with its own example. Scan the QR to open this lesson.
