The TOCOL and TOROW functions are just two ways to rearrange data in Microsoft Excel. For example, you can flip the rows and columns using the TRANSPOSE function, transform large datasets using ...
Combining Ctrl + Shift + Arrow keys lets you extend your selection in any direction until Excel hits a blank cell. Start from the top-left corner of your data, try Ctrl + Shift + Right Arrow, then ...