One of the main advantages of using this calculation program is that it allows you to have many layout options at the time of working on it. This is because this software has a great variety of functions and elements that allow you to carry out a very complete and professional work.
However, on many occasions when you are already working with some document and a large part of it has been done, is that the need arises have structured the spreadsheet a little differentlyeither to give you a better looking and much more attractive to the reader.
Either because you have not entered any of the column headings, either line header or vice versa, among many others. Luckily for all users who work with Microsoft software they will have the opportunity to make a transposition of the data they are handling. This is how we will explain a little more here what this function is aboutFor this, follow in detail everything that we will explain below.
What is transpose and what is it for in a spreadsheet?
This function called transpose in Excel it will help you move data from one side to another within the worksheet in a much easier way. That is why it must be used every time data is handled in columns and these need be rotated to rearrange them into rows or vice versa. Therefore, this tool allows you copy and paste using the transpose option.
However, you should bear in mind that at the time of carrying out this process, creating duplicate data, for this not to happen it will be necessary to write a formula instead of the transpose function, which should be as follows as an example formula = TRANSPOSE (A1: B4), where will they be taken the values of cells A1 and B4 to organize them.
Steps to transpose data from one column to a row and vice versa in Microsoft Excel
In case you want transpose data from one column to a row to rearrange your worksheet It will be necessary to carry out each of the steps that we are going to indicate below, in this case it will be taken as an example that a column header in worksheetthis can be from employees, products, finance, among any other topic. Note that when applying this function, this column will be transformed into a row.
Accordingly, follow each of the instructions that we will indicate below:
- The first thing will be to select each of the rows of the columns you want to transpose. You can do this by clicking on the first row and then dragging the selection through the rest. You can also click on the first row and hold the key Shift and then you click on the last data.
- If you try to select the columns and then continue with the next steps of "Copy and paste", it is very likely that you will see a error notice where you will be told that the area to be copied and the pasting paste are not the same size. That is why it is necessary to select the rows for the columns as explained in the previous step, so that the process is carried out satisfactorily.
- Now you should copy the rows, for this you can do it by selecting the option of "Edit" in the menu and then selecting "Copy" or using "Command + C" through the keyboard.
- Next, click on the cell where you want to paste the data.
- Here we select the arrow next to the button "Paste" on the ribbon and then select the option "Transpose".
- If what you want is to apply a additional format on the sheet, then you can select the option of "Paste special" on the menu "Paste". To do this, a window will open where you can select all the format options. Then click on the option "Transpose" and once finished select "OKAY".
- Once all the above steps have been completed, the selected columns will become rows. In case you want convert the rows into columns you just have to follow the same process.
