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.”
Tag: Array Functions
Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64
Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64
WRAPCOL & SORTBY Array Functions to Pivot A Table. “Robustify” your formulas!
Download Excel File: https://excelisfun.net/files/EMT1784-1785.xlsm
Learn how to pivot a table using the WRAPCOL and SORTBY Array Functions. See SORT, TRANSPOSE and UNIQUE functions also. Convert a table to a cross tabulated table.
Topics:
1. (00:00) Introduction
2. (00:22) Look at the Continue reading “WRAPCOL & SORTBY Array Functions to Pivot A Table. “Robustify” your formulas!”