Press Ctrl+Alt+V > Mark the Transpose checkbox.Select our new data set and press Ctrl+C > Select a location ( K4) to place the output finally.It may seem that we have lost our new data set! We’re three more steps behind our desired transposed data table. Replace all “ =” characters with “ abc” or any letters that are not present in the data set > Click on Replace All.Or, press Ctrl+H instead and get to the Replace Tab directly. Open Excel’s Find and Replace dialog box.You have to redo the format unless you want it gone! Along with that, we see that the format is also gone. We have just linked it up with our original data set. The new data set is now at the cell range of B11:I16. Go to the Paste Special menu by pressing Ctrl+Alt+V > Click on Paste Link.Select your desired range of cells ( B4:I9) > Ctrl+C > Select the desired location ( B11).Following the steps below, let’s see how to do this. So, we need a method that’ll link up the output with the initial data set and will update accordingly. Read More: Transpose Multiple Rows in Group to Columns in Excel.ġ.2 Transpose a Table and Link It to the Initial DataĪ drawback of the method above is due to a change in any data in the initial data set, it won’t change in the transposed data set. So, we have generated the transposed data set from our initial data set. Mark the Transpose checkbox.Īlternatively, You can also open the Paste Special menu using the keyboard shortcut Ctrl+Alt+V. Choose the cell location ( B11) where you finally want the output.You can also use the keyboard shortcut Ctrl+C instead. First of all, select the range of cells ( B4:I9) you want to transpose.
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 described below. Use Paste Special Command and Link to Transpose Rows to Columns In the following sections, we will show 5 instrumental excel methods to perform this task.ġ. We want to transpose the rows of this data set to columns for the sake of better presentation. 5 Useful Methods to Transpose Rows to Columns in ExcelĪssuming that we have a data set that presents the year-wise results of some students.
0 kommentar(er)
