From the course: Excel: Lookup Functions in Depth

Unlock this course with a free trial

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

WRAPROWS and WRAPCOLS: Convert row or column data into an array

WRAPROWS and WRAPCOLS: Convert row or column data into an array - Microsoft Excel Tutorial

From the course: Excel: Lookup Functions in Depth

Start my 1-month free trial Buy for my team

WRAPROWS and WRAPCOLS: Convert row or column data into an array

“

- [Instructor] On this worksheet called Wrap, we've got a list in columns A and B. Imagine we've been recording these sales, small business may be out of your home, month by month, starting in 2012. And as I press Control + Down Arrow, imagine it's early 2025, we've recorded some numbers there. The business has grown. We've been putting our monthly entries in one by one every month in column B. What we'd like to be able to do in addition to this is have a grid type list here. We could create a chart from it. We'd like to see all those numbers at once. And as we continue to add new data in that column, we want them to appear up in column S for 2025. The function we're about to use is called WRAPCOLS, C-O-L-S. We're going to be wrapping some columns of data. Think of these as potential columns. Here's the 2012 data. We want to put that over in column F or a copy of it. We want to do that for all the other months as well too. So a companion function is called WRAPROWS. In cell F2, we…

Contents