Excel VSTACK HSTACK - How to Combine Multiple Data Tables with Source Table Name Column Added

Learn how to combine multiple data tables with an additional source table (range, sheet) name column using VSTACK & HSTACK functions in Excel.

Functions used: VSTACK, HSTACK, MAKEARRAY, LAMBDA, IF, ROWS

#excel #combine #data

[teoxengineer]

This functional tutorial is endless thanks for video.
Apparently, the PQ calculation methodology began to occur in Excel formulas.
It has been quite complementary to combine HSTACK and VSTACK formulas with the LAMBDA function. We are able to create this formula with the Office365 with the EXPAND formula.
What I want to ask,
Can we combine different tables and show the combined tables, repeat to pivot as well as showing which table of these data is coming from?

[TheOligopeptide]

Thank you that is really interesting. Excel is starting to look better and better compared to google sheets since I don't have any programming skills (I know I should start learning at least one programming language being that it is the future). One question though....when you create those custom formulas in a excel spreadsheet, will you be able to to use those in new workbooks or you have to recreate them each time you are working in a new workbook?

[eiger]

Hi, thank you for this very full of contents tutorial, by the way i don't have both functions HSTACK & VSTACK in the Excel version i use. May i ask you whitch version you do use? Thank's again

[nikithau]

Hey, can we get the new results in end of data, using vstack

[usmanahmad]

Can we add HANDLEBLANK before VSTACK function only once??

[zunkman]

Is there a way to do this in Google Sheets?