Glide Training Logo

Use TOROW and TOCOL to combine data into a single row or column in Sheets and Excel


In this quick tip we show you how to make use of the powerful TOROW and TOCOL functions that allow you to combine data from a range of cells into a single row or column. The process is exactly the same in Google Sheets and Microsoft Excel.

If you’d like to see more hints and tips on how to get the best out of the software and apps you use every day, take a look at our YouTube channel. Follow us for regular updates!

Let’s Take It Further

Could you or your team benefit from some face-to-face training?

Glide Training is one of the leading providers of professional IT training in the UK.

We provide training on Microsoft and Google products including Excel, Docs, Word, Sheets, PowerPoint, Slides, Project and more, delivered on-site at your premises or online.

Unlike most training companies we won’t try to sell you a set course from a fixed list; rather we will discuss your specific requirements and work with you to deliver a training programme that gives you what you need to succeed.

find out more

previous post: Move around an Excel workbook using the Navigation Pane

next post: Use SORT to keep dropdown lists in A-Z order in Excel and Google Sheets