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.

New VSTACK and HSTACK functions

New VSTACK and HSTACK functions - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

New VSTACK and HSTACK functions

“

- [Instructor] Two relatively new functions in Excel 2 are called VSTACK, think of V for vertical, 3 and HSTACK, H for horizontal. 4 Imagine this scenario where we have three separate lists 5 and you could imagine them being much larger, 6 for the moment they're small or easy to deal with. 7 We want to have a single list elsewhere. 8 Now, on a real life scenario, 9 perhaps these would be on separate worksheets, 10 maybe even in separate workbooks. 11 But we want a list that collects 12 all this information and also reflects changes 13 that might occur in these initial smaller lists. 14 We'll be using VSTACK, we're going to be 15 stacking these three clusters of information 16 into a single three column layout. 17 The next worksheet over is called VSTACK. 18 It's currently empty, equal VSTACK. 19 As you type this function, name equal vs, 20 we can press tab as the only function 21 beginning with those two letters. 22…

Contents