🆕 How to Use WRAPROWS & WRAPCOLS Function in Excel

Published: 04 June 2023
on channel: Leila Gharani
73,845
4.2k

Join 300,000+ professionals in our courses: https://www.xelplus.com/courses/

Microsoft introduced some very useful new functions in Excel. You can use them to rearrange your data in a dynamic way.

With WRAPROWS you can take a row or column of values and make it into a table with rows and columns. You just need to tell it how many values you want in each row.

The WRAPCOLS function is a tool in Excel that lets you change the shape of a row or column of data. It lets you change a list of values into a table of values. It does this by putting some values in different columns.

Requires Microsoft 365. These functions will not be available in Excel 2021 and earlier versions.

🌍 My Online Excel Courses ► https://www.xelplus.com/courses/

🎬 LINK to more YouTube Shorts videos:    • Shorts (Tips, Tricks & Office Pranks)  

👕☕ Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/

🎓 Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/

🎥 RESOURCES I recommend: https://www.xelplus.com/resources/

More resources on my Amazon page: https://www.amazon.com/shop/leilagharani

🚩Let’s connect on social:
Instagram:   / lgharani  
Twitter:   / leilagharani  
LinkedIn:   / leilagharani  

👉 This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#Excel


Watch video 🆕 How to Use WRAPROWS & WRAPCOLS Function in Excel online, duration hours minute second in high quality that is uploaded to the channel Leila Gharani 04 June 2023. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 73,845 times and liked it 4.2 thousand visitors.