If you do this with cells that contain formulas, make sure to double-check the formulas after transposing the data to ensure everything copied correctly. The new data is in no way linked to the old data this means that if you change the original data, the new data set will not update. You can't paste the new data over the old data like you can with copy-paste-special. This will take a few times to learn before you can do it from memory but it will save you a lot of time. Go to where you want the data to be and select the upper left most cell where the data will go and use this keyboard shortcut: Alt + E + S + E and hit Enter.Select the original Data and hit Ctrl + C.If you want to perform the above steps to transpose or switch your data using keyboard shortcuts, that can be done in just a few steps. Quickly Transpose Data with Keyboard Shortcuts The new data is in no way linked to the original set of data. The original data will still exist, so, if you want to remove it, go ahead and do that. In the window that opens, select the Transpose option, which is located above the OK button then, hit the OK button.Right-click over the desired cell and click Paste Special:.Go to where you want the new data to be located and select the upper left most cell where that data should be placed:.(It will not work if you cut the data instead of copy it) Select the data set that you want to switch or reverse:.Steps to Switch the Rows/Columns of a Data Set in Excel This will save you hours when you need to "flip" a set of data in Excel.īelow, I'll show you the steps involved don't forget to download the accompanying workbook so you can follow along with this tutorial. How to switch a data set in Excel so that the columns become rows and the rows become columns.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |