TOCOL and DROP | 2 of the 14 new Excel functions | Unwinding a grid

/in /by

14 new functions were released into Excel recently. In this video I cover two of them:
TOCOL: converts a rectangular matrix into a single column
DROP: retrieves a rectangular array and drops (eliminates) columns that aren’t needed. One thing to know: you can drop columns starting from the beginning or end of a range. You can eliminate, say, the first 3 columns, but you cannot drop columns from the middle of the range.

I show this along with the UNIQUE and SORT functions, and a dropdown list and conditional formatting.

#TOCOL
#DynamicArrays
#ConditionalFormatting

For a list of my Excel courses at Lynda/LinkedIn:
https://www.linkedin.com/learning/instructors/oz-du-soleil
There are courses on Power Query, Good spreadsheet habits, and a weekly Excel challenge that comes out every Friday.

Website: https://ozdusoleil.com

My book: Guerrilla Data Analysis 2nd Edition

My old blog: http://datascopic.net/blog-2-2