There are many ways to transform your data within Microsoft Excel, and once you've learned how to utilize its functionality, it can be easy to dive right into making the most of your spreadsheet. But ...

TOCOL and TOROW functions. Excel is constantly being updated. TOCOL and TOROW are two new functions. TOCOL takes the input array (just a fancy name for a group of cells) and puts them all in a column.

Reshaping a two-dimensional array of data into a single column or row in Microsoft Excel streamlines the layout of your figures and makes for more efficient sorting and filtering. For these reasons, ...