+ Reply to Thread
Results 1 to 3 of 3

How can I move contents of every other cell in the same column to the adjacent row

  1. #1
    Registered User
    Join Date
    08-01-2013
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2008
    Posts
    1

    How can I move contents of every other cell in the same column to the adjacent row

    I really use excel for the most basic functions, so detailed explanation is appreciated.

    My sheet now has:
    A
    Name
    Address
    Name
    Addres

    And I'd like it to be:

    A B
    Name Address
    Name Address

  2. #2
    Forum Contributor
    Join Date
    06-26-2013
    Location
    LAX
    MS-Off Ver
    Excel 2007,Excel 2010
    Posts
    363

    Re: How can I move contents of every other cell in the same column to the adjacent row

    See if attached kind of approach works for you..
    Attached Files Attached Files

  3. #3
    Valued Forum Contributor
    Join Date
    09-25-2011
    Location
    Eastbourne, England
    MS-Off Ver
    Excel 2010
    Posts
    1,089

    Re: How can I move contents of every other cell in the same column to the adjacent row

    Hi eb21biggie

    Another approach is as attached.

    Regards
    Alastair
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Insert Column Adjacent to Cell If Cell Contents Anything Other Than Condition
    By Jrub in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 03-20-2013, 03:45 PM
  2. Replies: 2
    Last Post: 03-28-2012, 11:47 AM
  3. Move cell value from one column to another based on contents
    By uncleslinky in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-30-2011, 06:44 AM
  4. Move cell contents to another column IF
    By Scott Wagner in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-17-2006, 03:25 PM
  5. Replies: 1
    Last Post: 07-01-2005, 10:57 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1