Vertically Stack and Sort Data with Curly Brackets

Learn how to vertically stack and sort data in Google Sheets using a simple trick with curly brackets, eliminating the need for the VStack formula.

Anything we change is automatically changed here. I showed you in a previous video how to use VStack and sort . Two formulas you can combine so that automatically any new data is sorted . But I want to show you one more way to do this. We don't even need the VStack formula here. We can actually use a little trick called curly brackets. Put two curly brackets here and we need two ranges that are divided by semicolon. So the first range will be exactly the same range as we before, and the second range will be the second range here. And all we need is the curly brackets. Vertically Stack and Sort Data Your First Formula in Google Sheets Automate Two Sheets

Big Year 2027 calendar: the whole year on one Google Sheet

Free 2027 calendar.Plan all of 2027 on one Google Sheet, free.

Copy it to your Google Drive.

Get it free