![]() ![]() But, it does not keep the source formatting and links it to a transposed table. This method is also quicker in converting rows to columns in Excel. When a user wants to keep the same connections of the rotating table with the original table, it can use a transposing method using a formula. It shows how the transpose function is performed to convert rows to columns. In the above figure, copy the data which needs to be transposed and then click on the down arrow of the Paste option and form the options select Transpose.Then, a “Paste Special” dialog box will appear from which select the “Transpose” option.Then, select the down arrow from the toolbar under the “Paste” option and select “Paste Transpose.” But the easy way is to right-click the blank you chose first to paste the data. Paste the data by pressing the “Ctrl +V” keys starting at the first blank space or cell. Select a blank cell and ensure it is outside the original data range.Then, Copy the selected data by simply pressing Ctrl + C keys. ![]() Select the whole data which needs to be transformed or transposed. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |