From the course: Excel Weekly Challenge

Unlock this course with a free trial

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

Convert performer roster

Convert performer roster - Microsoft Excel Tutorial

From the course: Excel Weekly Challenge

Start my 1-month free trial Buy for my team

Convert performer roster

“

- [Instructor] In column B, we have a list of performers. It's not so easy to read. What if we just want to look at clowns, or know who all of the magicians are? The main objective is to convert this data in B, to look like the roster that you see below the objectives box. The way the example is formatted is easy to see. Olivia is an acrobat, a magician, and a musician. We can see that we've got two magicians in the example, and they are Olivia and Rex. So that's what we want. Convert the source data into a matrix. And make sure that your solution is dynamic because I'm going to ask you to add more data. So, maybe Ted is more than an acrobat. Or you have new people that you want on this roster. Your solution needs to be able to update. Okay, pause the video, reformat this roster, and come on back. (upbeat music) Okay, let's get into it. My cursor is already in the dataset. I'm going to right click. Get Data from…

Contents