At times, you might had entered some data in rows and later realize that it should had been entered in columns. You can move the data in the rows to columns and vice versa. This is called transpose. To perform transpose of data, do the following:
1. Select the cells that you need to transpose.
2. On the
Home tab, in the
Clipboard group, click
Copy.
3. Click cell
A2 or the cell where you need to have the data.
4. On the
Home tab, in the
Clipboard group, click the down arrow in the
Paste command and click
Transpose.
Output:
0 comments:
Post a Comment