1. Select n copy data,
2. Place cursor where u want data
3. Goto Paste Special, (CTRL+SHFT+V)
4. Click to enable Transpose option, (E)
5. Click on OK (Enter)
Below snap will be helpful to understand ...
(click on image to enlarge)
Friday, February 24, 2017
Change Orientation of Data (Transpose)
Change orientation of data from rows to column and vice versa.
1. Select n copy data,
2. Place cursor where u want data
3. Goto Paste Special, (CTRL+SHFT+V)
4. Click to enable Transpose option, (E)
5. Click on OK (Enter)
Below snap will be helpful to understand ...
1. Select n copy data,
2. Place cursor where u want data
3. Goto Paste Special, (CTRL+SHFT+V)
4. Click to enable Transpose option, (E)
5. Click on OK (Enter)
Below snap will be helpful to understand ...
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment