How To Convert Columns To Rows And Rows To Columns Using TRANSPOSE In Excel
We cover how to convert columns to rows and vice versa in Excel. You may have come across situations where you have hundreds of rows of data which are showing vertically instead of horizontally and you don't know how to quickly convert them. In this video, we’ll first cover how to automatically convert columns to rows using the TRANSPOSE function, we’ll then cover how to do the same for rows to columns and finally we’ll cover how to incorporate the UNIQUE function to only transpose the unique columns or rows.
Subscribe for weekly Excel tutorials, techniques and examples:
/ @theexcelhub
Please share this video with others that may find it useful:
• How To Convert Columns To Rows And Ro...
Please comment below if you have any feedback or any suggestions for videos you would like us to upload next!
🌍 The Excel Hub website: https://theexcelhub.com/
📸 Instagram: / theexcelhub
ABOUT US:
The Excel Hub seeks to enhance your Excel and VBA knowledge by providing value-adding tutorials, techniques and examples in order to help you take your spreadsheet and data analysis skills to the next level.
For any enquiries, please contact:
[email protected]
Overview: (0:00)
Convert vertical to horizontal: (0:43)
Convert horizontal to vertical: (2:01)
Transpose unique columns and rows: (2:27)