Similarly, only values can be transposed, without the names of rows and the columns. Now the table header is located vertically (what is clearly visible due to the green color of the header), and the data are respectively located horizontally. The value formula was also copied and counted the product of price and quantity, but already with taking into account other cells. Moreover, we note that cells with the same content are highlighted in green. The rest we left as is and click OK.Īs a result we obtained the same table, but with different arrangement of the rows and the columns. In the window that appears we put the tick near the TRANSPOSE.We click on the command Paste Special (CTRL+ALT+V).We put the cursor anywhere in the Excel worksheet and right-click the menu.We select the entire table and copy it (CTRL + C).To transpose the table, we will use the SPECIAL INSERT command. We need to arrange the table`s data horizontally relative to the vertical arrangement of its header. For the sake of the clarity, the table header is highlighted in green color. The cost is calculated by the formula: price * quantity. The table cap is located horizontally, and the data is arranged vertically, respectively. We have the table with the price of a certain product per a piece and with certain amount of products. There are three ways to transport tables. In other words, it is a turn in two planes: horizontal and vertical ones. Transposing a table in Excel is the replacement of columns by rows and vice versa. The concept of «transport» almost does not occur in the work of PC users, but those ones who work with arrays, whether matrices in higher mathematics or the tables in Excel, have to face with this phenomenon necessary. Three ways how to transpose the table to Excel
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |