- Select the data to be changed, then copy (right click, select copy)
- Place the cursor in cell where data is moved, then do a right click and select Paste Special
- In the Paste Special menu, and tick theValue and Transpose
- Please see the results
Changing Data Horizontal to Vertical or Opposite
Sometimes we need to change our data entry in a vertical to a horizontal sequence. It can be seen from the sequence of steps
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment