Excellent video as usual. I would have used query function but I learned about both V and H stack here. LET function is also new to me and I will certainly be inserting that into some of my exisiting formulas that are a bit long in the tooth. Thanks
Excellent video sir. You made my day today. Learnt few extraordinary tips especially clubbing of Vstack and Hstack (selecting only few particular columns)- this is an extraordinary tip which helps me a lot.
This is by far the best method, thank you! Have you considered an extra column to have a partial data sheet's name for each row? I wonder how that can potentially look like
this is very well put together. Thanks for the tutorial! Do you have video about linking data from different files in Excel and GSheets? I am struggling a bit with Excel since they don't have IMPORTRANGE. And I wish to know some ways to feed the live data acros different Excel files stored on OneDrive. And if there is a way to do the same between OneDrive files and Gdrive sheets, that would be so cool!
Loved how you went step by step and then combined it all in one formula. I prefer to use query to combine data, but enjoyed learning about vstack, hstack, and let functions.
This particular example would be very difficult to recreate with QUERY function. With QUERY function you need to have at least one column where you can guarantee there will be some data, here you don't. QUERY function is also very particular with data types in your columns and it fails producing results when data types are not universally matched. For me personally, unless I have to use GROUP BY or PIVOT statements I pretty much never use QUERY function because I find it prone to failures.