Combine Data/Sheets in Excel & Google Sheets

Рет қаралды 12,470

Learn Google Sheets & Excel Spreadsheets

Күн бұрын

Combine Data/Sheets in Excel & Google Sheets.
00:00 Combine Data/Sheets in Excel & Google Sheets
00:25 VSTACK & HSTACK functions
05:35 Combine Ranges with Dynamic Updates in Excel & Google Sheets
09:33 BYROW & LAMBDA functions
13:22 LET function
16.53 Combine Multiple Worksheets to a Master Sheet in Excel & Google Sheets
20:54 How to Combine Data with Different Columns?
#excel #googlesheets

Пікірлер: 24

@anvi84 Жыл бұрын

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.

@ExcelGoogleSheets Жыл бұрын

I'm not a big fan of QUERY function, but that's just my experience.

@lpanebr Жыл бұрын

🤯 So many functions I had never heard of. Thank you! Even text join. I've always used the simple join...

@antyt2714 Жыл бұрын

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

@chakralamurali 6 ай бұрын

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.

@silvestrecamposano6317 9 ай бұрын

Thank you very much for all the formulas... I can use it in my office work...

@tridsonline Жыл бұрын

👍🏻 Thanks, great teaching technique! I'm looking forward to trying out some interesting new functions.

@ExcelGoogleSheets Жыл бұрын

👍

@xjarius Жыл бұрын

This is awesome, thank you so much for your clear teaching!

@ExcelGoogleSheets Жыл бұрын

👍

@przemysawhajduk8728 6 ай бұрын

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

@dannylayton317 Жыл бұрын

Another brilliant video - thank you!

@ExcelGoogleSheets Жыл бұрын

thank you

@lpanebr Жыл бұрын

Valeu!

@ExcelGoogleSheets Жыл бұрын

Thank You!

@sergheyzaporojanu6872 Жыл бұрын

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!

@tridibbiswas3361 Жыл бұрын

Thank you for the video. Where can I get the exercise files

@imamfachrudin7846 Жыл бұрын

Another option, we can create the range by combining with INDEX (we can get the last row from this)

@gzatt Жыл бұрын

can't u do all that with a simple query?

@gzatt Жыл бұрын

the verticals at least. And can u create a named function for that big function u made?

@imamfachrudin7846 Жыл бұрын

He gave another perspective brother

@ExcelGoogleSheets Жыл бұрын

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.

@ExcelGoogleSheets Жыл бұрын

Of course you can create a named function, but you could say that about any formula with nested functions.