Including Headers in VSTACK Data

In a previous post, I showed you how to combine data from several sheets into one sheet using the VSTACK function. You can watch the tutorial for that here: VSTACK to Combine Multiple Sheets.

Video Tutorial

Watch on YouTube & Subscribe to our Channel

Downloads

A common question that arises from the process is, “How do we add headers?”

How to include headers with VSTACK

Good question!

There are two quick ways to add headers to the stacked data.

The first way is to copy and paste the headers from the first sheet, but that's not very flexible.

Copy and paste headers

The second way is to add the headers into the VSTACK formula.

To do that, edit your VSTACK formula so that the headers from your first tab come before the data range you've already specified. Separate this new data range from the existing range with a comma.

You are essentially adding another array and stacking the header line on top of the other stacked data.

VSTACK Headers

Now, if your headers on the first tab ever change, the changes will automatically reflect in your combined VSTACK data.

Header add to VSTACK formula

Pretty simple, right?

If you have any questions, just ask in the comments and we'll get back to you as soon as we are able.

Add comment

Your email address will not be published. Required fields are marked *

Generic filters
Exact matches only

Excel Shortcuts List

keyboard shortcuts list banner

Learn over 270 Excel keyboard & mouse shortcuts for Windows & Mac.

Excel Shortcuts List

Join Our Weekly Newsletter

The Excel Pro Tips Newsletter is packed with tips & techniques to help you master Excel.

Join Our Free Newsletter