Good day,
This week, let's make data entry a whole lot easier. These tips in the video below will save you time and headaches - let me know what you think!
Excel AI for Fixing Macros
Our automated tool for fixing and updating macros in Excel - this was built for complete novices to use!
We're adding more features now that the mvp has been completed - please reply to this email and let me know what else you'd like us to add to it!
Can’t see the thumbnail? Click here to watch on YouTube
Last Week's Tutorial: Excel’s Secret Search Feature
Funny Work-Humor Clip
A little office humor from us to start the week, courtesy of YouTube Shorts.
[Tiny Tip] Combine Tables on a Single Sheet with This Formula
If you have two or more tables, you can combine them into one clean list with a single formula. No Power Query, no copy and paste, and no helper columns. |
The Formula
=FILTER(VSTACK(A2:C10, E2:G10), VSTACK(A2:A10, E2:E10)<>"") |
Tip: click into the box and copy the formula.
Example
If you have one table in A2:C10 and another table in E2:G10, this formula stacks the second table underneath the first one.
A2:C10 |
the formula returns one combined list with blank rows removed.
How It Works
VSTACK places one table under the other.
FILTER removes rows where the first column is blank.
The result is a clean combined table that updates automatically.
Notes
Both tables should have the same number of columns. This formula works in newer versions of Excel that include dynamic array formulas.
Excel AI for Fixing Macros
Courses
Cheers and see you next week!
Don