Data Transformation / Cleaning by Power Query

In the data transformation and cleaning process for Ship Date and Location:

1. Ship Date: I reformatted the dates to a clearer format (day/month/year), making the data more consistent and easier to read.

2. Location: I split the Location data into two new columns: Country and City, instead of having them combined in one column. This allows for more flexibility in analysis and enables sorting or filtering by country and city separately.