+ Reply to Thread
Results 1 to 4 of 4

[solved]Moving columns

  1. #1
    Registered User
    Join Date
    07-29-2013
    Location
    /
    MS-Off Ver
    Office 365
    Posts
    4

    Post [solved]Moving columns

    Hello everyone,
    I am glad to find this great forum. I am sure I can learn a lot about Excel through this great forum with a lot of experts and professionals!
    I'm using Excel 2003
    Here is the question.
    In short, I want all the data in A3 to B2, A5 to B4, A7 to B6
    Original data
    A2 Peter
    A3 brother
    A4 Mary
    A5 Mother
    A6 Sam
    A7 Father

    Wanted to be listed as follow

    A2 Peter B2 brother
    A3 Mary B3 Mother
    A4 Sam B4 Father

    I'm sure many of you awesome guys know the formula or the trick. My excel skills are really poor... Thank you so much! I really appreciate your help!
    Attached Files Attached Files
    Last edited by kwokhin; 07-29-2013 at 01:29 PM.

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    13,217

    Re: Moving columns

    See the green cells in the attached file.

    e2=INDIRECT("A"&(row()-1)*2) and drag down.

    f2=INDIRECT("A"&((row()-1)*2)+1) and drag down.
    Attached Files Attached Files
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Registered User
    Join Date
    07-29-2013
    Location
    /
    MS-Off Ver
    Office 365
    Posts
    4

    Re: Moving columns

    Quote Originally Posted by oeldere View Post
    See the green cells in the attached file.

    e2=INDIRECT("A"&(row()-1)*2) and drag down.

    f2=INDIRECT("A"&((row()-1)*2)+1) and drag down.
    UTTERLY AMAZING!
    Exactly what I want to do!
    I didn't expect such a detailed reply in this short period of time!
    I really appreciate your help with all my heart!
    I don't have to keep copy&paste now. Thank you so much!
    I should really start learning some basic stuff about Excel

  4. #4
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    13,217

    Re: [solved]Moving columns

    Thanks for the reply.

    Glad I could help.

    You can add rep(utation)points to the one who helped you by clicking on the start (on the left side).

+ 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. [SOLVED] Moving data from two columns into multiple columns
    By blindzero678 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-19-2012, 10:12 PM
  2. Moving columns into one row
    By oliver79 in forum Excel General
    Replies: 5
    Last Post: 06-24-2010, 04:04 AM
  3. Moving columns into one
    By oliver79 in forum Excel General
    Replies: 1
    Last Post: 06-23-2010, 03:07 AM
  4. moving columns to a new sheet
    By craigmacca in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-12-2006, 10:57 AM
  5. Moving rows to columns
    By Jan Verten in forum Excel General
    Replies: 5
    Last Post: 09-02-2005, 12:05 PM

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