Try this Data Transformation Challenge before you watch the next video!

The steps for this section's challenge are included in S13_Excel_PowerQuery_Start.xlsx in the Challenge Tab.

What you need to do:

You receive a data set that has total values in the middle of the data. It also contains Division AND region information in one column.

You'd like to analyze the data with a Pivot Table. But you can't properly analyse the data until you have a tabular data set.

You decide to use Get & Transform / Power Query to clean the data.

Let me know how you did!

I share my version in the solution video (coming up next). It's also included in the final version of the workbook for this section: S13_Excel_PowerQuery_.xlsx.