How to use TOCOL and TOROW Functions in Excel
Availability:
Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web
The TOCOL Function returns the array in a single column while the TOROW Function returns the array in a single row