Excel Magic Trick 1425

Convert 2-Way Table to Single Column Table with INDEX & Number Increment

DESCRIPTION

See how to use INDEX function & Number Increments to Convert 2-Way Table to Single Column Table:
(00:11) Introduction
(00:52) Copy Paste Trick to Convert 2-Way Table to Single Column Table
(01:46) Number Increment for Row Number using ROWS and ROUNDUP Function
(04:00) Number Increment for Column Number using ROWS and MOD Function
(05:22) INDEX Function to extract columns in Two Way Table into a Single Column
(06:38) Summary

WORKBOOKS

Download “Excel Magic Trick 1421 1426.zip” Excel-Magic-Trick-1421-1426.zip – Downloaded 36 times – 1 MB







Be the first to comment

Leave a Reply