From the course: Excel Power User Challenge

Unlock this course with a free trial

Join today to access over 24,900 courses taught by industry experts.

Convert records from a matrix to a single column

Convert records from a matrix to a single column - Microsoft Excel Tutorial

From the course: Excel Power User Challenge

Start my 1-month free trial Buy for my team

Convert records from a matrix to a single column

“

- We have unstacked data in the past, and now we need to stack the data. When we're working with data, we have to shape data in all kinds of ways. And maybe we need the big tall stack because we're going to upload it to a database or something. And that's the format that it needs to be in. So check out the data. We've got Apple Spring Central High School, the principal, founded date, and this is the format we need. We want the school, principal, mascot, founded date, and then school, principal, mascot, founded date, one big column, and you got to be crafty. Think about how you're going to do this, all right? Pause the video, get it stacked, come on back. And we're going to have a stacking good time. (upbeat music) Okay let's get into this, and let's run like Mustangs, like the mascot at Lawton Green High School, here we go. I'm going to move this out of the way. And notice that there is a pattern. We need B3 at the top and…

Contents