How to Use TOCOL | TOROW Function in Excel

Published: 06 August 2023
on channel: Leila Gharani
61,710
4.1k

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

You're going to love the new TOCOL & TOROW functions in Microsoft Excel! TOCOL lets you dynamically combine cells across multiple columns and rows into a single column. The TOROW function is very similar - you can combine data from different cells into a single row. In this video I'll show you how it works.

Requires Microsoft 365. The TOCOL & TOROW functions will not be available in Excel 2021 and earlier versions.

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

👕☕ 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