From the course: Excel Tips Weekly

Unlock this course with a free trial

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

Restructure column/row data using new WRAPROWS and WRAPCOLS functions

Restructure column/row data using new WRAPROWS and WRAPCOLS functions - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Restructure column/row data using new WRAPROWS and WRAPCOLS functions

“

- [Instructor] Two relatively new functions 2 are called WRAPROWS and WRAPCOLS, 3 and they're analogous to two functions you might have seen 4 in an earlier weekly tip, T-O-C-O-L, meaning two column, 5 and T-O-R-O-W, meaning two row. 6 And the red panel on the screen here 7 suggests what we're about to do. 8 We've got a big list over in columns A and B. 9 We've been tracking sales back to 2011. 10 Imagine a small business, maybe home-based, 11 and it gets larger and larger. 12 The chart to the right is actually based on that data 13 and maybe when we set up the data, 14 we weren't thinking long term. 15 We just kept it that way, 16 and every time there's a new entry, 17 we just go to the bottom and put in the new sales. 18 And we've got our charts so that it will grow with the data. 19 And you can see, based on the chart, 20 the erratic nature of the sales too. 21 They bounce up and down a lot, generally growing…

Contents