From the course: Excel Weekly Challenge

Unlock this course with a free trial

Join today to access over 22,600 courses taught by industry experts.

Sort and stack

Sort and stack - Microsoft Excel Tutorial

From the course: Excel Weekly Challenge

Start my 1-month free trial Buy for my team

Sort and stack

“

- [Instructor] Oh wow, look at this. We had somebody helping us compile all of this data but she had to go. She had an emergency, couldn't finish it. Here we are, when we've got it in these three separate pieces. So our objective to finish this, stack these three pieces of data into one dataset. We do not need that name field. And then sort the final dataset two ways. First by the category, smallest to largest and then by amount, largest to smallest. One piece of advice, don't overthink this. Pause the video, pull up the exercise file, work it out, come back and I'll show you a solution. Okay, let's do this. And my warning about not overthinking this is because we could start thinking about some fancy formula or something, but no, sometimes you just grab stuff and move. And I'm going to show you one of my favorite keyboard shortcuts. Let's stack this up. I'm going to highlight this first dataset. I'm going to…

Contents