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.

Unpivot and split columns

Unpivot and split columns - Microsoft Excel Tutorial

From the course: Excel Weekly Challenge

Start my 1-month free trial Buy for my team

Unpivot and split columns

“

- [Instructor] We've got a list of people, the hours they worked, and at which store. So we see Alice worked three hours at B333. We would like a list that shows the names, the hours worked, and the days. We see that Ethan worked Monday and Wednesday. We would like two entries Ethan Monday Ethan Wednesday. To do this we're going to unpivot, split columns, then get rid of the store codes and keep the hours. Then close and load to the workbook. The next step would be to add the Thursday data that's in column L and then refresh. All right, work that out, come back, and we'll go through it together. Okay you're back, let's dive in. I'm going to put my cursor in the data set. Data from table/range. The names are highlighted, right click. Unpivot other columns. Let's call this day instead of attribute. And then split this column, the value column, highlight that, split column by delimiter, it's already guessing that we want…

Contents