In this lesson, we will learn how to convert between columns and rows in Excel. So, we will convert rows to columns and columns to rows.
Assuming we have the following data in a table.
To convert between rows and columns, we will perform the following steps:
1- We select the table.
2- We click the right mouse button, and from the options we choose “Cut”, which will cut the table.
3- We go to any other place within Excel and click the right mouse button, and from the options, we will choose “Past Special”.
4- From the interface that will appear, we will indicate the option “Transpose”.
Dear reader, if you liked the article, do not forget to subscribe to our YouTube channel, which provides all new in the field of technical and completely free training courses.
You can also browse our website to access the blog and read technical topics, or learn about the training courses offered by the site.
To access the full course “Excel Course” on YouTube, click here.