Combine Excel Sheets the EASY Way with VSTACK

[@iamdrdeath]

I like this function. I've utilized the Filter function to return the stacks after watching this works a treat and much easier!!! Thanks

[@marjoriestevens3668]

Just what I needed. So easy to follow. Thank you 😊

[@TeachersTech]

Glad it was helpful!

[@koidamiracle8929]

Your teachings are always good with better explanation

[@TeachersTech]

Glad you think so!

[@IvanCortinas_ES]

Excellent explanation. Thank you!

[@TeachersTech]

You’re welcome!

[@user-bk7tr6qu7n]

Thank you very much. Do I have a way to preserve the original formatting such as colors or bolds?

[@JB_inks]

Ctrl-Shit home and end also go to the first and last cells on a sheet with data

[@StefanoVerugi]

I understand this is just an example, maybe in real life those tables are better used as named type range so you can dynamically stack them without problem in case they expand vertically.. right? thanks for the video

[@TeachersTech]

My preferred method for this would be power query to bring all the sheets together and clean the data. Easy to refresh for new data.

[@StefanoVerugi]

@@TeachersTech yes, it's the right way to go, totally agree 👍 But, for large datasets, maybe python pandas would be more efficient?

[@tammymarik]

Is there a way to do this with out getting duplicates ? I'm looking for something to import new data only. Like fill in data where its missing, but not re-add the data that is already there.... i hope this makes sense.

[@jeffreyscottfishman]

Could you please send the link of your video on basic excel for beginners if you have one? I'm just not good at this. I just need to know the basics on starting out for the first time. Thanks

[@TeachersTech]

Here you go! kzbin.info/www/bejne/oWK5ho17i9p3gJo

[@LiamBriggs18]

kzbin.info/www/bejne/p4e3nZyldtaIrJosi=dk6kRvheFM1UUnm- This one's his 3 hour masterclass, it's probably more comprehensive than you're looking for, but it's a great reference for you to jump in and out of

[@jeffreyscottfishman]

Thank you!

[@nikosmakrymanolakis3042]

I'd do it with named tables, and then just VSTACK(Table1;Table2;...). And when lines are added/deleted on original source tables, VSTACK output will adjusted automatically. Why bother with lines?

[@TeachersTech]

Yes, using spill functions like VSTACK, tables are a great way to have it dynamically adjust.