Download Excel File: https://excelisfun.net/files/EMT1784-1785.xlsm
Learn how to convert a rectangle of data with row headers and columns headers into a proper table of data using Array Functions such as DROP, EXPAND, TOCOL and INDEX.
Topics:
1. (00:00) Introduction
2. (00:30) Continue reading “TOCOL, DROP, EXPAND Array Functions to UnPivot Data into Proper Table.”
![](https://i0.wp.com/bonbonsguide.com/wp/wp-content/uploads/2022/03/BFAqPfSXtk.jpg?fit=480%2C360&ssl=1)