HT201232: Contact Apple for support and service

Learn about Contact Apple for support and service
caefromvancouver
Level 1 (8 points)
iWork

Q: numbers

Have a six column roster set up which is currently 3 pages.  Is it possible to move one name,address,phone listing from columns 1/2/3 over to columns 4/5/6 without changing other listings.

example  have too many names in 1/2/3, page 3 and want to move last name up to top of 4/5/6 and having others drop down in column to open space .....

MacBook Pro, Mac OS X (10.6)

Posted on Jul 29, 2016 4:15 PM

Close
caefromvancouver

Q: numbers

  • All replies
  • Helpful answers

  • by Barry,

    Barry Barry Jul 29, 2016 5:15 PM in response to caefromvancouver
    Level 7 (32,271 points)
    Jul 29, 2016 5:15 PM in response to caefromvancouver

    Hi cae,

     

    This assumes that all entries on the page are entered data, not generated by a formula in the cell(s).

     

    The easiest route is probably to

    • Select all of the entries in columns D, E and F.

    Screen Shot 2016-07-29 at 5.00.41 PM.png

    • With the cells selected, click on the name in D2, and drag the group down one row, dropping it wen the pointer is in cell D3. (Two)

    Screen Shot 2016-07-29 at 5.06.01 PM.png

    • Select the three cells containing the last entry in columns A, B and C. Copy. (Three)

    Screen Shot 2016-07-29 at 5.07.46 PM.png

    • Select the three empty cells at the top of columns D, E and F. Paste (Four)
      (For short tables, you can drag and drop as done above.)

    Screen Shot 2016-07-29 at 5.10.24 PM.png

    • Click on the Row reference tab for row 8. Click on the  v beside the 8, Choose Delete Row.

    Screen Shot 2016-07-29 at 5.13.13 PM.png

     

    • Done.

     

    Regards,

    Barry