From the course: Excel: Managing and Analyzing Data

Unlock this course with a free trial

Join today to access over 24,400 courses taught by industry experts.

Convert an array to a column with TOCOL

Convert an array to a column with TOCOL - Microsoft Excel Tutorial

From the course: Excel: Managing and Analyzing Data

Start my 1-month free trial Buy for my team

Convert an array to a column with TOCOL

“

- [Instructor] Here's a common need. We have a matrix of data, and it's easy to see who played in match eight, right, those five people. But now we want to do something with the data itself. One question is how many individual players are in here? We've got Al at least two times that I can see, but I would like a list that has Al one time, Max one time. And then get a count also, how many people have played just one time. Here we're going to use a dynamic array function. I'm going to go to the player's list and equals TOCOL open parentheses. What is the array that I want to turn into a column? I'm going to highlight the range and enter. Oh, we got a SPILL error, why? Because the dynamic array is telling us that it does not have enough room for the result that it has. Click here, look at that. That line is telling us how many rows it needs. Okay, I slide this out of the way, and put it right here, boom, there is the full result. But what its done, is taken the entire array and put it…

Contents