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.
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.
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
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!
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.
![Megan Thee Stallion - Roc Steady (feat. Flo Milli) [Official Video]](http://i.ytimg.com/vi/HozPPyqW0dY/mqdefault.jpg)
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.
I'm not a big fan of QUERY function, but that's just my experience.
🤯 So many functions I had never heard of. Thank you! Even text join. I've always used the simple join...
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.
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
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
Thank you very much for all the formulas... I can use it in my office work...
This is awesome, thank you so much for your clear teaching!
👍
👍🏻 Thanks, great teaching technique! I'm looking forward to trying out some interesting new functions.
👍
Another brilliant video - thank you!
thank you
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!
Thank you for the video. Where can I get the exercise files
Another option, we can create the range by combining with INDEX (we can get the last row from this)
Valeu!
Thank You!
can't u do all that with a simple query?
the verticals at least. And can u create a named function for that big function u made?
He gave another perspective brother
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.
Of course you can create a named function, but you could say that about any formula with nested functions.
No need for that fancy formula in excel, only in google sheets