DATA CLEANING - POWER QUERY

This project involved cleaning a badly structured data.

Below is the picture of the unstructured data;

Steps to cleaning the data;

1. I deleted the last two steps on the applied steps,  the ship mode row is to be transposed and so should be a row not a header.

2. I transposed the first column to make the ship mode and segment columns

PS: Whatever you need to unpivot needs to be a header, so I used the first row as a header

3. Iselected the ship mode and segments, went to the unpivot button and selected "unpivot other columns"

PS: Some datesacquired an underscore after i unpivoted(this is because some of the dates were repeated or repeated consecutively)

4. I used "Extract" to extract only the dates without the underscores

5. I changed the data type of some of the columns

6. I renamed some of the columns.

Below is a picture of the cleaned data set;

Attached is a copy of the data set containing the raw(unstructured data) and the cleaned data.

You can also go through the power query editor to see what the table looked like at each cleaning stage.