One of the main advantages of using this calculation program is that it allows you to have many design options when working on it. This is because this software has a great variety of and elements that allow you to carry out a very thorough and professional work.
However, on many occasions when you are already working with some document and a large part of it has been made, is that the need arises to have structured the spreadsheet a little differentlyeither to give a look better and make it much more attractive to the reader.
either because you have not entered any of the headers of the either line header or vice versa, among many others. Fortunately, 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 here we are going to explain a little more about what this function is about, for this, follow everything that we will explain below in detail.
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 to be rotated to rearrange them in or vice versa. Therefore, this tool allows you copy and paste wearing the transpose option.
However, you must keep in mind that at the moment of carrying out this process, the creating duplicate dataso that this does not happen it will be necessary to write a formula instead of transpose functionwhich should be as follows as an example formula= TRANSPOSE(A1:B4), where will they be taken the values of cells A1 and B4 to arrange them.
Steps to transpose data from a column to a row and vice versa in Microsoft Excel
In case you want transpose data from a column to a row to reorganize your worksheet it will be necessary for you to carry out each of the steps that we are going to indicate below, in this case the example will be that a column header in the worksheetthis can be from employees, products, financesamong any other topic. Note that When applying this function, said column will be transformed into a row.
Accordingly, follow each of the instructions that we are going to 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 for the rest. You can also click on the first row and hold down the key “Shift” and then you click on the last data.
- If you try to select the columns then continue with the following steps of “Copy and paste”, it is very probable that a error message where you will be told that the area to be copied and the area to be pasted do not have the same size. That is why it is necessary to select rows to columns as explained in the previous step, so that the process is carried out satisfactorily.
- now you must copy the rowsfor this you can do it by selecting the option “Edit” in the menu and then selecting “Copy” or using “Command + C” through the keyboard.
- The next thing will be to 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 “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 you finish selecting “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.
Facebook Comments
Disqus