Use the TRANSPOSE function to switch rows and columns
Syntax: TRANSPOSE(array)
Step 1: Select an empty range with the same number of rows and columns as the original data range.
For all things Strategy, Management Theories, and Business Frameworks, please visit https://www.stratrix.com