From the course: Excel: PivotTables for Beginners

Unlock this course with a free trial

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

Solution: Clean and structure a raw dataset

Solution: Clean and structure a raw dataset

From the course: Excel: PivotTables for Beginners

Start my 1-month free trial Buy for my team

Solution: Clean and structure a raw dataset

“

So let's take a look at the solution for this challenge. For this, I've decided that I'm going to use Power Query. So let's click somewhere in the dataset, and then I'm going to jump up to the Data tab. In the Get and Transform Data group, I'm going to choose From Table or Range. Now, where it says where is the data for your table, you can see it's picked up a cell range. If we take a look at that, we can see the marching ants around the outside. Now, you might be thinking to yourself, well, that looks a little bit weird. It doesn't look like it's picked up all the data. It actually has because all of this data is contained within one column. If I just cancel here for a second, if I double-click to widen out this column, you can see that everything is actually in column B. So let's click on from table range again. I'm going to say yes, my table has headers and click on okay and that's going to open up the Power Query Editor and import that data. So here is my data again all in one…

Contents