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?

[@nikithau1465]

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

[@usmanahmad7758]

Can we add HANDLEBLANK before VSTACK function only once??

[@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?

[@ExcelGoogleSheets]

You'll have to recreate them in other workbooks.

[@zunkman1]

Is there a way to do this in Google Sheets?

[@ExcelGoogleSheets]

Yes, but not using the same formula.

[@natew]

@@ExcelGoogleSheets could you do a video on this or link to one that you recommend? I know the query function could accomplish this. Hard to match column headers though. Keep think dget could get us there as well on sheets.

[@ExcelGoogleSheets]

Here is one kzbin.info/www/bejne/enXPmWZ7g5uBjJo

[@damian4601]

​@@ExcelGoogleSheets maybe a part 2 for this? I know {,} and {;} can do the same. They are equivalent to function calls of Array_row and Array_literal.

[@eiger67]

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

[@ExcelGoogleSheets]

365 preview

[@Al-Ahdal]

1st comment