+ Reply to Thread
Results 1 to 4 of 4

Move Multiple-Rows of Data to One Column (not Transpose)

  1. 03-26-2014, 10:41 AM #1
    T0ny
    T0ny is offline
    Registered User
    Join Date
    03-26-2014
    Location
    Earth
    MS-Off Ver
    Excel 2010
    Posts
    3

    Post Move Multiple-Rows of Data to One Column (not Transpose)

    Greetings. I am using Excel 2010. I have several cells filled with data from using the auto insert function, however I can not get the data in sequential order. Each row has 7 cells of data. I want to maintain the data being in order and place off of this into one column.

    Example:

    CURRENTLY
    A1 B1 C1 D1 E1 F1 G1 etc.
    A2 B2 C2 D2 E2 F2 G2
    A3 B3 C3 D3 E3 F3 G3
    A4 B4 C4 D4 E4 F4 G4

    DESIRED
    A1
    B1
    C1
    D1
    E1
    F1
    G1
    A2
    B2
    C2
    D2
    E2
    F2
    G2
    A3
    etc.

    I found a similar type of question from CriticalEric "Move Multiple-Column Data to One Column (not Transpose)" http://www.excelforum.com/excel-gene...transpose.html

    Thank you.
    Reply With QuoteRegister To Reply
  2. 03-26-2014, 10:58 AM #2
    Tony Valko
    Tony Valko is offline
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Move Multiple-Rows of Data to One Column (not Transpose)

    One way...

    Data:

    Sheet1
    A
    B
    C
    D
    E
    F
    G
    1
    A1
    B1
    C1
    D1
    E1
    F1
    G1
    2
    A2
    B2
    C2
    D2
    E2
    F2
    G2
    3
    A3
    B3
    C3
    D3
    E3
    F3
    G3
    4
    A4
    B4
    C4
    D4
    E4
    F4
    G4
    5
    -----
    -----
    -----
    -----
    -----
    -----
    -----


    Results:

    Sheet1
    I
    1
    A1
    2
    B1
    3
    C1
    4
    D1
    5
    E1
    6
    F1
    7
    G1
    8
    A2
    9
    B2
    10
    C2
    11
    D2
    12
    E2
    13
    F2
    14
    G2
    15
    A3
    16
    B3
    17
    C3
    18
    D3
    19
    E3
    20
    F3
    21
    G3
    22
    A4
    23
    B4
    24
    C4
    25
    D4
    26
    E4
    27
    F4
    28
    G4
    29
    -----


    This formula entered in I1 and copied down until you get blanks:

    =IF(ROWS(I$1:I1)>COUNTA(A$1:G$4),"",OFFSET(A$1,INT((ROWS(I$1:I1)-1)/7),MOD(ROWS(I$1:I1)-1,7)))
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.
    Reply With QuoteRegister To Reply
  3. 03-26-2014, 11:20 AM #3
    T0ny
    T0ny is offline
    Registered User
    Join Date
    03-26-2014
    Location
    Earth
    MS-Off Ver
    Excel 2010
    Posts
    3

    Thumbs up Re: Move Multiple-Rows of Data to One Column (not Transpose)

    Thank you for your help.
    Reply With QuoteRegister To Reply
  4. 03-26-2014, 01:20 PM #4
    Tony Valko
    Tony Valko is offline
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Move Multiple-Rows of Data to One Column (not Transpose)

    You're welcome!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to transpose variable data from column A to multiple rows
    By Davidko19 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-13-2014, 01:31 PM
  2. Transpose Variable Data from Column A to Multiple Rows
    By downthesun in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-24-2013, 06:45 AM
  3. [SOLVED] Transpose multiple duplicate rows into relevant column data
    By SimonN in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-27-2013, 06:51 AM
  4. how to transpose data from one column into multiple rows?
    By gabrielemucho in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-11-2012, 11:11 AM
  5. Move Multiple-Column Data to One Column (not Transpose)
    By CriticalEric in forum Excel General
    Replies: 5
    Last Post: 04-22-2012, 07:17 PM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1