Excel Magic Trick 1425: Convert 2-Way Table to Single Column Table with INDEX & Number Incrementor

Download File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT1425-1426.xlsx Entire page with all Excel Files for All Videos: http://people.highline.edu/mgirvin/excelisfun.htm See how to use INDEX function & Number Incrementors to Convert 2-Way Table to Single Column Table: 1. (00:11) Introduction 2. (00:52) Copy Paste Trick to Convert 2-Way Table to Single Column Table 3. (01:46) Number Incrementor for Row Number using ROWS and ROUNDUP Function 4. (04:00) Number Incrementor for Column Number using ROWS and MOD Function 5. (05:22) INDEX Function to extract columns in Two Way Table into a Single Column 6. (06:38) Summary