How to Unpivot Data in Excel using formulas?
Unpivoting data is a method in data transformation, allowing you to transform complex data into structured data. In this video, we'll show you how to unpivot data in Excel using simple formulas with TOCOL, CHOOSECOLS and SEQUENCE functions.
Here’s what we’ll cover:
2:22 - Setup & Table Creation - Convert data into a table
2:40 - Creating the YEAR Column - Generate a sequence for each year.
4:31 - Generating the QUARTER Column - Repeat quarters across years.
5:42 - Creating the SALES Column - Collect data across quarters.
7:25 - Tips to use the functions for various other types of datasets.
With Excel’s TOCOL and SEQUENCE functions, you can unpivot various other datasets such as monthly, annual or weekly datasets.
For more read our the article on Unpivoting data: https://indzara.com/how-to-unpivot-da...
Our Data Visualization Toolkit: https://indzara.com/product/data-visu...
Don’t forget to subscribe for more Excel tutorials!
