Unpivoting and transposing

Northwind traders is a specialty food and beverage supplier for small and medium businesses. They maintain a steady stream of business with many supermarkets and restaurants throughout the United States. They only use Excel for keeping track of their business, and want to update their practices to make use of more refined analysis techniques.

Check out the bottom section of this MSFT Learn Article to learn more about unpivoting.

Your first task is to clean up the sales data for the year 1997, which is presented in a unique way that the company is used to operating with. You will use the transpose and unpivot features to get the dataset into a much more appropriate structure for analyzing in Power BI.