Lab Overview: Congratulations! You have been hired as a data person at an online store! The company that you are working for is called Productsrus and they sell things over the internet through different Markets or Stores.Currently, they are switching systems, they need you to do the T part of an ETL Pipeline. They need you to go through and format their old data with their new data requirements.

This includes:

Change the dates so that they dont come in with a time.

They also need to show this type of format when the cell is formatted

Add a column with the day of the week the sale was performed

Any IMEIs that are on more than one line and put a comma in between them

Anything that is a currency amount to be formatted as such.

They would also like a column added to the end that shows the data from columns I and J concatenated after you do the changes above, they would like another sheet containing the following information given a customer name they would like to see what that customer bought store and item number combined in one field they would like to know which day of the week has the highest sales.