How to use the WRAPCOLS and WRAPROWS Functions in Excel to Format Your Data! #howto #tutorial #wow

In this tutorial, I show you how to use the WRAPCOLS and WRAPROWS functions in Microsoft Excel! Both of these functions are pretty cool because they allow you to get a vector of data, and format in a way that makes it easier to use. The both have similar arguments, with the first argument being VECTOR which is the data that you want to to format, the next argument is WRAP_COUNT, which is the maximum number of values you want in a given column in the WRAPCOL function, or the maximum number of values for a given row in the WRAPROWS function. The last argument is optional, and is the PAD_WITH, which basically allows any remainders to be returned in something different than NA, like a blank value. I hope that you found this tutorial to be helpful, and if you did please like, subscribe, and comment. Thank you for watching, and I hope that you have a great day!

My Official Patron Page -

Get a fancy gadget!

Get an amazing new laptop!!

Keyboard Shortcut Cheat Sheet Anyone?

[RobertWoodman]

Hi, and thank you for this video. Can you use WRAPCOLS and WRAPROWS with named tables? I see what the formulas can do. In the workplace, how are these formulas used?