How to combine tables with VSTACK in Excel!

[@Toby_K]

This guy did a 100% Excel run

[@largeoctahedron]

Every time I learn something about Excel the more I realize it’s just the world’s most painful coding environment

[@marymotherofgod4861]

Same ugh😮😮😮😮😮😮

[@jimg4059]

Honestly, I’m a power user, and you’ve taught me a few really interesting applications for various formulas that have legit helped my workflow. Thanks dog!

[@NoName-NoGimmicks]

The first second of an Easy Sheets video is equal to the euphoric anticipation of hearing about a great movie from your friends then the day comes when you see it yourself. Never knew watching an Excel Master would be simultaneously jaw-dropping and awe-inspiring.

[@bigt6928]

This will be so helpful! Thank You for this information!😊

[@farzinjahed9575]

He is rapidly becoming my favorite KZbin shorts channel. He is always teaching something useful.

[@YoucefYoucef-ft9ce]

I'm an accountant I'm using this method all time. Thank you for your efforts. Youcef from Manhattan

[@Ginupop]

While I didn't learn it from this video the Vstack Filter combo is great, and you can easily use it on files stored in a different networked drive. Saved my bacon! The more people who know, the better!

[@cruzinsweetsntreats]

It's also faster in loading, than using Power Query to bring it in as a table. Especially coming from multiple workbooks.

[@cruzinsweetsntreats]

With the Insider Beta, VSTACK & HSTACK load on Excel for Android.

[@mikemcculley]

The original sin was splitting the data across the sheets in the first place.

[@Viazm]

Yes but sometimes it depends fom others

[@dallasgirl3470]

It's necessary sometimes

[@ManasMadrecha]

Filtering empty rows was cool

[@misterwill3625]

It was 👏🏾

[@Stevencyw88]

Great sharing. This is super useful

[@johnathanhunter9359]

Bro I just got an accounting internship where I do reconciliations in excel everyday. I have never subscribed to a channel faster!

[@leowu1644]

Public accounting?

[@alexc.2783]

This is it! This is the thing I needed for the last 3 years for my budget sheets! Dude, I'm subscribed!

[@marcus2259]

Helpful when you want to edit a specific sheet without scrolling for too long.

[@CodexEvans]

Dark Master, the supplicant kneels to absorb more of your wisdom!

[@budisutrisno2083]

Useful. I have sheets with same format but i know nothing to combine them into one sheet. Thank you for showing this technique. It's cool bro...

[@ravitejaa5672]

Excellent💯👍

[@FadhilBasery]

Very useful! I collect and record monthly data, this is really helpful to make yearly summary. Thank you! 😊

[@alexwhitehead2186]

Just used this..... worked a treat!! thanks so much

[@thebluelord_25]

At this point, this guy's gonna run Doom in Excel soon.

[@melaD333]

Brilliant.. going to try this today!!

[@publiusii4246]

I don't know what I did to have Google decide I needed useful excel tricks in my shorts but I'm commenting so the algorithm keeps doing it

[@aliwaqar3720]

Nicee👍🏻

[@ayna4641]

Nice❤

[@croskoal]

Great tip. I've never seen this formula before, and it looks amazingly useful

[@brianzibricky]

I never though Brad Pitt could provide such excellent Excel tips, but here we are.

[@fdm2155]

I don't even use Excel very much but this is amazing.

[@akumaten]

I like that dynamic aspects

[@mayajanaka]

All the videos so useful 🎉🎉🎉🎉 thank you so much 🙏

[@umesh2403]

This was what I was looking for ages..since when is it available?

[@aashishshrestha1252]

Cool😊

[@misterwill3625]

Another awesome, informative video. 👏🏾 There’s been times when this would’ve helped. This is why I follow you. I’m sure this will come up again at work

[@shugotenchi]

I can almost HEAR my work PC melting down into unbelievably radioactive butterscotch crunch processing 500,000x11 volatile cell values.

[@YRSHAHI]

Great

[@nordborn9706]

Great stuff. Straight to the point. ❤

[@petersibanda5218]

Great!

[@bigbaby91]

Data > Get Data > From Tables > once all loaded > Append Queries as new

[@Boomk27]

This is what I’d do too.

[@sassouusasoo3607]

Most people don’t know about power query .

[@fauzibaharumify]

Using power query right?

[@easy_sheets]

Power query is amazing

[@arunkt8184]

​@@easy_sheets Pls do the video about Power query.

[@grinfacelaxu]

Nice

[@rawat3668]

superb

[@kHoPhAe]

Do you know you’ve made me a genius at work? 😂

[@user-ht5ce2it3z]

I don't even use Excel anymore and these fascinating me for some reason.

[@aSpyIntheHaus]

Gold!

[@dauskamaruddin3272]

thanks for the information..

[@melaD333]

Tried this but couldn’t get the filter portion to work but it still works great because I’m using a pivot table as well. Exactly what I needed. Thank you!!

[@jamesclark2020]

Beautiful.

[@nosuchthing8]

Wow

[@makhosazanasibeko9666]

I've wanted this function, thanks

[@Soundwave1of9]

Very good! Thank you

[@maxmustermann3093]

Top! Thank you!

[@homelander2768]

Easy decision! Subscribed

[@mzinzin]

Love it

[@no-damn-alias]

Thank you.

[@clubley2]

Would this not work without the filter if you just format the tables as tables? This is the second video I've seen from this channel, both are using undefined tables where formatting as a table would reduce the complexity.

[@verygoodboy2688]

Neat but im just gonna filter by blank and delete those rows. Much easier and cleaner than nesting functions

[@bhaggoporiksha2940]

Great..Thank U Good Samaritan❤.

[@Selenzell]

İ have been trying to do something like this for quite some time and i couldnt figüre out how. Thanks a lot ❤

[@rempitizm]

Thank you, great tool.

[@ahsanfareed354]

Thank you so much ❤

[@GordonSux]

This shit is genius.

[@sachavez100]

This is handy.

[@Zinkyness]

I really need to take an excel course, lol.

[@easy_sheets]

I'm about to release one!

[@mtn66amassuonoobpawa35]

You know you're getting older when your fyp recomands you exel tips...

[@cihanseraykut518]

Omg!! thank you

[@ewnetuawraris6858]

Thanks Dude! Problem Solved

[@ZyadSV]

I hope when I need to add data like this to remember this way, but I'm sure I won’t

[@bakchormeeman7864]

Copy and pasting does the exact same thing but is so much less complicated.. I mean.. this just feels like you’ve made your life harder for no reason at all

[@ScottMattes]

Would be nice if the version of excel vstack is in would be mentioned

[@chedisLoL]

Up to date. Usually O365. If you can’t pull up the date when the function is added (which takes the same amount of time as your comment) then dont even comment.

[@ScottMattes]

@@chedisLoL why not, the goal of putting these videos out is to be helpful so that info would be helpful - a great many people still work at places that don't use the latest and greatest

[@cruzinsweetsntreats]

Referencing the version, such as Insiders Beta of Office 365 is a caveat, as not everyone has it. Though there is a free tool to upgrade.

[@ariarc]

All these new functions are so time saving, recently I finally decided to get the 365 subscription. It's turned out to be cheaper than buying the physical software only for it to be outdated in a couple of months.

[@John-jt3dn]

you can do thid by using filter in { ... } also

[@Zer0Gravity31]

Queries work a little better for an easier data appendage

[@garmo1968]

If the data on the other sheets are formatted as table then you don't need the extra space by dynamically targeting the table column it'll grow automatically Also instead of filter try using sort instead it would dump your empties to the bottom of the list

[@911Salvage]

Dumping blank rows is more preferable most of the time.

[@garmo1968]

@@911Salvage I agree I prefer finding ways to avoid including them to begin with most

[@sadaqitali5703]

nice

[@cruzinsweetsntreats]

HSTACK allows you to bring in split columns

[@WorldSeriesBound]

My brain ploded

[@fauzibaharumify]

What about using power query to combine all excel tabs?

[@BeerTrooper]

Is this also working in the Office 365?

[@John-li1df]

Why need the extra space. ?

[@ANunes06]

I've shat on some other tips, but this is actual real shit. =FILTER(VSTACK()) is based.

[@olmasbeksharipov2963]

You can do this with power query

[@phylectures2023]

Hi, just like this, is there any option to sum all the similar data on multiple sheets to a single master sheet?? (In Google sheets?)

[@Whiskeyj456]

A few months ago I got sick of having to export csv’s from a vendor for daily reporting at my job and having to append them together. Found out we have api integration with that vendor and decided to learn SQL. Wrote a query for it and now I just have an auto refreshable dashboard in power bi, saving me a ton of time each day. Only downfall? I’m now the “data” guy for my department and busier than all hell.

[@alializadeh8195]

thanx

[@marcins5235]

Thnx

[@getdatmoneymane9930]

Like bro what???? How do i even know this Btw this channel was literally my fastest sub

[@Blee48]

Turn all tabs to a table source. Merge all on power query. Done... No formula needed

[@arielbene2013]

please help i can only stack using commas .. i cant choose multiple sheets and multiple cells

[@shoddits2156]

you should mention that this function only available to excel for microsoft 365

[@Ir._Fan]

Why would i add those extra sells for the first place. If i didn't add any extra sell, there wont be any empty sells, isn’t it like this?

[@michaelwinter742]

Make your range B2:E

[@jaydnbaker1127]

Now, how do you do that with multiple excel documents?

[@mechtist]

damn, i wrote a macro to do this a few days ago lol! it's only 9 (necessary) lines of vba.

[@goodvibes4144]

In my excel sheet this formula now showing so, now what I have to do!?

[@HarshMelon]

You use this with tables so you don't have to do the filter?

[@pabspurba]

How about the reverse version?

[@maxkp361]

I don't have the filter formula why that?

[@albacan]

Its time to enable verbal instructions

[@blowave313]

What's VSTACK function in french please ?

[@uphdennyalexander]

Can i do it in excel 2019?

[@olegariocamara9308]

Very nice, but I don't use formulas anymore. I switched to power query

[@kevalvichare4759]

Hello sir , How to convert xlsx file into pdf version

[@Ashishization1]

What is dynamic?