If you’ve ever needed to combine multiple ranges or arrays side-by-side in Excel, the HSTACK function is your friend.
HSTACK lets you stack arrays horizontally, meaning you can place data from different columns or ranges next to each other in a single formula, without manually copying and pasting or using complex formulas.
How does HSTACK work?
Simply provide the arrays or ranges you want to combine as arguments, and Excel will join them horizontally into one combined array. It even supports formulas as arguments, letting you create columns on-the-fly.
It’s perfect for consolidating data, creating dynamic dashboards, or preparing data for further analysis.
Want to see HSTACK in action? Check out the video where I walk you through how to use this powerful function step-by-step, along with practical examples you can try yourself.
Download a copy of the file(s) used in this video: https://share.zight.com/yAuRn6J1
These are the formulas that I used in the video:
=HSTACK(Sheet1!B2:B21,Sheet1!C2:C21,Sheet1!F2:F21)
=HSTACK(Sheet1!A2:A21,Sheet1!B2:B21&" "&Sheet1!C2:C21,Sheet1!E2:E21,MONTH(Sheet1!G2:G21))