![]() In this scenario, you can change its orientation from the current horizontal range to the vertical range with the help of the paste special option in excel. Sometimes, when you have huge number of columns, column data at the end is not visible, and it does not fit to screen. So when we copy this dataset to the horizontal direction, it should contain 7 column cells towards the other direction so that the overlapping does not occur with the original dataset. In the above-mentioned example, there are 7-row cells that are arranged vertically. Note: In the other direction where you are going to copy raw or source data, you have to ensure to select the same number of cells as the original set of cells so that there is no overlapping with the original dataset. pasted data, which is referred to as transposed data.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |