Unpivot data using formulas
Dinesh Natarajan Mohan
Reporting and Analytics Leader | Simple Tools & Smarter Decisions | 1.5M+ Template Downloads on INDZARA.com
Unpivoting data is a common task in data transformation. In this article, we will learn how to use simple formulas to unpivot. It can also be done using Power Query. Both approaches have their pros and cons. Unpivoting using formulas is a good technique to have in your arsenal.
Using the data on the left, we will be writing 3 formulas to create the YEAR, QUARTER and SALES columns on the right.
Watch Video Demo
I use a quarterly sales data in this exercise. You can use the same concept to unpivot other datasets such as monthly, annual or weekly datasets.
Thank you for taking the time to read this edition of my newsletter. I hope you found the content valuable. If you did, please consider subscribing to stay updated with future editions. Also, I invite you to join our growing community on my YouTube channel for more in-depth analysis and unique content.
Your support and engagement are greatly appreciated and help fuel this journey of shared knowledge and growth. I am looking forward to connecting with you further!