Data comes in different shapes and Excel provides us with amazing functions to transform these different shapes into the most suitable structure for our analysis. In this article, we will…