Using Paste Special alone gives you static data. Transpose Data using Paste Special and Find & Replace If you want these transposed cells to be linked to the original cells, you can combine the power of Find & Replace with Paste Special. Note that the copied data is static, and if you make any changes in the original data set, those changes would not be reflected in the transposed data. If you only want to copy the value, select ‘value’ in the paste special dialog box. The steps shown above copies the value, the formula (if any), as well as the format. Below is a demo showing the entire process. This would instantly copy and paste the data but in such a way that it has been transposed.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |