I like this function. I've utilized the Filter function to return the stacks after watching this works a treat and much easier!!! Thanks
@marjoriestevens36684 ай бұрын
Just what I needed. So easy to follow. Thank you 😊
@TeachersTech4 ай бұрын
Glad it was helpful!
@koidamiracle89294 ай бұрын
Your teachings are always good with better explanation
@TeachersTech4 ай бұрын
Glad you think so!
@IvanCortinas_ES4 ай бұрын
Excellent explanation. Thank you!
@TeachersTech4 ай бұрын
You’re welcome!
@user-bk7tr6qu7n11 күн бұрын
Thank you very much. Do I have a way to preserve the original formatting such as colors or bolds?
@JB_inks4 ай бұрын
Ctrl-Shit home and end also go to the first and last cells on a sheet with data
@StefanoVerugi4 ай бұрын
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
@TeachersTech4 ай бұрын
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.
@StefanoVerugi4 ай бұрын
@@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.
@jeffreyscottfishman4 ай бұрын
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
@TeachersTech4 ай бұрын
Here you go! kzbin.info/www/bejne/oWK5ho17i9p3gJo
@LiamBriggs184 ай бұрын
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
@jeffreyscottfishman4 ай бұрын
Thank you!
@nikosmakrymanolakis30424 ай бұрын
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?
@TeachersTech4 ай бұрын
Yes, using spill functions like VSTACK, tables are a great way to have it dynamically adjust.