How to use the WRAPCOLS and WRAPROWS Functions in Excel to Format Your Data!
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 -
/ exceltutorials
Get Office 2021 - https://amzn.to/3ib2Fcw
Get a fancy gadget!
https://amzn.to/3ptt2ee
Get an amazing new laptop!!
https://amzn.to/33aP6PU
Keyboard Shortcut Cheat Sheet Anyone?
https://amzn.to/3z1Q4Mx