VSTACK function - Microsoft Support

I’m not in the business of advocating people use Excel. But, for those situations where Excel is the quiet workhorse of your org (check in with your friends in finance and personnel!), turns out VSTACK is the function to consolidate multiple ranges into one. (e.g., if you’re trying to tidy data split into multiple sheets, where the sheets are a stand-in for some variable.)

Google Sheets equivalent would be, e.g., ={Sheet1!A:C;Sheet2!A:C} or =QUERY(…).

R tidyverse equivalent would be row_bind. (Would we could just use R.)

12:06 pm on November 21, 2022