How to combine multiple Excel sheets into one (without copying & pasting): 📊 • Create a new sheet • =VSTACK in cell A1 • Hold Shift and select all sheets • Last select the range you want to stack Done, all sheets combined into one!

Love using spreadsheets, but hate the time it takes to make them? Be up and running in minutes, not hours. 💵 Budgets 🏃🏻‍♂️ Fitness logs 💸 Debt Calculators ✅ Habit trackers & more. Checkout my template library here:

Want more tips like this? Get a weekly dose of Excel and Google Sheets tips straight to your inbox: Join 25K+ others and sign up below. It's free.

Needed this a week a ago. But better late than never. Thanks for sharing

Omg. I love this. Wish I had known this 2 days ago. Thanks for sharing. I am sure this is gonna save me lots of time in the future

This is gonna save a lot of time. Thank you @blakeaburge. Always love your content 🙆🏻

you need to release one big course already. you're giving away too much value for free 😂

Love it!

Do you have a YouTube channel that shows all the tips you show here?

@SaveToNotion #thread #excel

Whenever new excel features or functions are explained, could u mention in your msg which excel version supports these functions. Eg Excel 2010,2016 .I tried using VSTACK function, but realised that this function is not avbl in old excel version but is MS 365. Thanks in advance.

@SaveToBookmarks

Hi Blake, Please is it possible to automate data transposition in Power Query? And what's the best approach when the data set is repeated in column but you need to change it to rows. Thanks