![]() ![]() Immediately, the Paste Special dialog box will pop up.Īs a result, you can see the new output in the B11:G18 range which is the transposed form of the dataset. Hereafter, select Paste Special from the drop-down list. ![]() Later, click on the Paste drop-down icon on the Clipboard group.Afterward, choose cell B11 where you finally want the output.After that, click on the Copy icon on the Clipboard group of commands.First of all, select cells in the B4:I9 range that you want to transpose.However, let’s see how this method works. This method is quick and easy, but it’s not suited for repeated processes. We can use the simple Paste Special command in two ways, as described below. Please leave a comment if any part of this article does not work in your version. Here, we have used the Microsoft Excel 365 version, you may use any other version according to your convenience. In the following sections, we will show 6 instrumental Excel methods to perform this task. ![]() Now, we want to transpose the rows of this data set to columns for the sake of better presentation. This dataset includes the Names and consecutive year-wise results under column B to column I. 6 Methods to Transpose Rows to Columns in ExcelĪssuming that we have a data set that presents the year-wise Results of Students. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |