# Excel How To Combine Tables with a Single Formula

If you have ever tried to combine data from different tables manually, that is a lot of copy/paste! In this post, I’ll show you how to use Excel’s VSTACK function so you can do it instantly with a single formula. No copy/paste needed!!

## Step by Step

Let’s say you have a table in Excel with January’s transactions. Perhaps it is named Jan and looks something like this:

You also have a different table for February named Feb:

And you have a March table named Mar:

Now, you’d like to combine them all and create something like this:

Rather than copy/paste Jan, copy/paste Feb, and copy/paste Mar, we can use VSTACK.

## VSTACK

The VSTACK function is designed to allow you to combine data from multiple tables/ranges. The underlying assumption is that the tables have the same columns and the same column order. If so, you can easily combine them with the VSTACK function.

For example, to combine the transactions from our Jan, Feb, and Mar tables:

`=VSTACK(Jan, Feb, Mar)`

You basically enter the table names as function arguments and hit enter. That’s it! You now have all of the transactions combined.

To include a header row, like in the screenshot above, just update the formula like this:

`=VSTACK(Jan[#Headers], Jan, Feb, Mar)`

Now the Jan table’s header row will be stacked on top.

## Dynamic

Plus, the best part is that this is dynamic. So, if you add another transaction to any table, it will automatically show up in the combined results table without any extra steps 🙂

Note: the VSTACK function is not available in every version of Excel. If you are using Excel Online or a fairly modern version, you should have it available. If you have a legacy version of Excel that doesn’t include VSTACK, you can check out Power Query’s merge/append feature instead.

## Sample file

If you have any other tips or suggestions, please share by posting a comment below … thanks!

Posted in ,

### Jeff Lenning

I love sharing the things I've learned about Excel, and I built Excel University to help me do that. My motto is: Learn Excel. Work Faster.

### Excel is not what it used to be.

You need the Excel Proficiency Roadmap now. Includes 6 steps for a successful journey, 3 things to avoid, and weekly Excel tips.

### Want to learn Excel?

Our training programs start at \$29 and will help you learn Excel quickly.

1. Sonata McPhail on March 21, 2023 at 8:30 am

This is awesome! I have attended several of Jeff’s webinars and they are of amazing value. I wish I learned some of the tricks I know now when I was in public accounting. It would have certainly helped during tax season!

2. JS on June 21, 2023 at 8:38 am

Many thanks indeed Jeff. I was struggling with trying join several tables using power query. This is much simpler and easier to manage!

3. Kathy on April 23, 2024 at 11:02 pm

Is there a way to do a pivot table from this? This is the exact thing I want to do, but I’m not really interested in a large table with everything, I just want to see a year to date summary of spending as I go.