Damn, I thought I was an excel wizard but 70% of the time I see your videos I learn something new 😂😂

@NotTheDAHASAG

Жыл бұрын

There's always a bigger fish

@indraa3854

9 ай бұрын

Dunning kruger effect

@phandongexcel

5 ай бұрын

www.youtube.com/@phandongexcel this my channel

Using VSTACK in Excel is like building a data sandwich - stack it right for a tasty treat!

Holy crap - I've used Excel for 20+ years and I've learned more in like 10 days being subscribed to your channel. Well done!!

The best channel - thank you ! You have made it so simple yet functional! Love watching your Channel!

It's unbelievable how many of these vids I email to my work account. Dude is a magician

@zeruzio1345

9 ай бұрын

This guy is definitely 30+ 😂

I love the data in your tables.

Had to learn power bi to combine tables in a singular one. This is much easier

Thanks for helping all of us to learn about Excel Shortcuts in an easy way.🤝😊

Looks like Mr. Krabs won't be monopolizing Krabby Patties much longer since Squidward bought the recipe for it.

Wow. I learnt something very useful today.

Kanye west as a salesman! 😂 I’ll never see this guys videos the same. Educational and funny! You sir have earned a follow.

Fantastic! Saving this for future reference.

NICE! Thanks...this is the 5 mins hacks i been waiting for!

This guy is a life saver

Hey, you are really a boss!

Incredible, thank you so much for sharing!

Handy knowledge. Thank you

GAME CHANGER OMG. I'm embarrassed to stay what silly processes/workarounds I've been doing to achieve this LOL.😅

Love you man for that alone ❤

Omg! I need that so much but couldn't find it anywhere!!!! 🎉🎉

Awesome 👏

I’ve been trying to figure this out for months! Thank you!

Awesome! Thank you

Excellent . Thanks a lot

saved my night. heaps of thanks. 😁

Fantastic

Your shorts are so cool, i wonder if you can do something like this to words and powerpoint presentation

How in the world do you know these things? I've used Excel for decades and had no idea it provided such functionality. Your videos are so eye-opening and helpful.

YOU ROCK!!! thanks heaps!!

Super

Append will also work as well 😉

U deserve to be subscribed you don’t even learn all this in excel class and ur giving all this knowledge for free.

Omg needed this video today!!! Thank you!!!

Thank you so much finally I found this

Thanks for this!

Thanks ❤

Thank you so much brother

I like this video ❤❤❤❤

A damn shame b/c array helper functions (and lambda helper functions) hasn’t come to semi annual channels

Beautiful

This is great, thanks!

Quick and easy video to explain how to do exactly what is said in title

Very useful. Thank you

Wow, that's awesome, great 👍👍👍

Bro, u deserve nobel prize!

Amazing

Thank a lot, i really appreciate

This is amaaazing

I just cried watching this video. 😭

Awesome

Excellent

Nice!

Can you put ur shorts in a Playlist?

Is it possible to "safe" this short in a list in youtube so i can find it again??

Excellent ! Thanks for This useful tip « Assemb »

Customer names are cool😂

Hi could you please explain how can we copy every 4 column data from the big data available in 1 sheet to other sheet

Nice

You just saved me soo much time. Thank you! Does this work for tables with data placed horizontally?

@TheDiego1255

10 ай бұрын

HSTACK

Same process can be done by using Power Query!!

Snoopy bought a portal gun.

Is there a way to show which table the data comes from?

So in the backend all tables are just arrays? Nice.

Bruuuh :))) that’s great!!!

❤

Do columns for all the tables need to be the exact same? Or will excel combine tables still with only some of the same columns and line it up correcty?

Thank you! I've wasted so much time copy&pasting 🤦‍♂️

Still believe the military needs a Microsoft office class. This info would have helped 10 years ago

So good! Loving these videos. What’s software do you use to record them / edit? So cool how you pan across the screen recording to keep it in a vertical format.

Can I do something like this in Access?

Snow White needs that dragon ball to wake up

Power query is also good

How to covert vstack result into actual data so it can be viewed on other versions on excel without the vstack function?

@Horn_of_Afrika

8 ай бұрын

Copy & paste as value

Can you do that but also have it eliminate duplicate rows if the same row / record exists in both tables?

Question: Why/when would you use VSTACK vs. PivotTable? Thank you

$3,208 for spinach. Nah Goku is embezzling for the cartels again.

💯

Damn, 10 seconds of work that will save you hours in the future.

I see you are a dragon ball fan, man of culture

Or you can get with the times and use power query.....

@easy_sheets

Жыл бұрын

not always necessary

Can we use this fuction in 2007 excel?

Is there anything like this for excel 2016?

doesn't seem to work with the lastest updates unless u have a 365 subscription, would had been nice to know that at the begining of the video

Silly question, can you do a swiss tournament pairing generator on excel?

Does that only work for one sheet? Or can you do the table stack from multiple sheets to one sheet?

@easy_sheets

Жыл бұрын

as many as you want

@westhood3284

Жыл бұрын

@@easy_sheets sweet thanks, I’ll try it for my PK-TCG checklists.

How will it automatically update on the All Sales sheet, if in the April_Sales table you used $E$13 instead of E13?

Can you do this if one tablee has additional columns - such as salesman's state ?

@easy_sheets

8 ай бұрын

Yes, just make sure the other columns line up

Do you have to use an underscore instead of a space, or is that a personal preference?

@Squirtle0411

Жыл бұрын

Can’t use spaces when naming tables - it’s a way to separate the words

@EjaeA

Жыл бұрын

I use period, but it seems underscore is cleaner

Bro sold birdperson a dragonball

And how to do the same in an older version of excel?

In which window this function is opret

Can we do reverse? Like all sales to separate sheet.

@easy_sheets

Жыл бұрын

Yes, you can use the filter function

Hi how can I set chart in Google sheet . I had "date an time an data " and I wanna to step it sheet. Format is like 2023/06/19. 23:55:34.578.356

How about unvstack? How can we split table by sheets

@easy_sheets

11 ай бұрын

The FILTER function!

Hello, can this v stack be done in another excel?

I have 100 sheeta how to combine with vstack function

Only available in Office 365 ? I do not see that office 21

You have duplicates of the individuals though

@easy_sheets

Жыл бұрын

yes the table is recording individual transactions not cumulative

Can someone explain what the meaning of dynamic data is? The simplest definition if possible hahahha

@easy_sheets

Жыл бұрын

Meaning that it updates automatically

@Yokenshiro11

Жыл бұрын

well that mean that if u add data in table 1 or 2 it will be automaticly ("ddynamicly") updated in the all table (vstack one)

Is it in any excel version Or only 365 or what