+ Reply to Thread
Results 1 to 2 of 2

Align several columns into 1 columns

  1. #1
    Registered User
    Join Date
    05-26-2016
    Location
    Montreal
    MS-Off Ver
    2013
    Posts
    10

    Red face Align several columns into 1 columns

    I have 3 columns:
    -------------------
    a D g
    b E h
    c F

    and would like to have them aligned into 1 single column:
    --------------------------------------------------------------
    a
    b
    c
    D
    E
    F
    g
    h

    Any suggestion for what i could best use for this purpose.
    In reality, i have about 200 columns with different number of rows.
    So i need to align smarter than manually.

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,065

    Re: Align several columns into 1 columns

    This will work for your example

    in D1
    =INDEX(A$1:C$3,MOD(ROW()-1,3)+1,QUOTIENT(ROW()-1,3)+1)
    and copy down

    Since you have 200 columns this solution may not work, you may need to change ALL the 3's int he formula to however many columns you have
    This also assumes that all columns have the same number of rows filled in.
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

+ 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] Align Columns
    By StreekyD in forum Excel General
    Replies: 26
    Last Post: 03-20-2019, 07:05 PM
  2. How to align columns
    By eyedoc in forum Excel General
    Replies: 8
    Last Post: 11-22-2014, 03:27 PM
  3. [SOLVED] Align 3 columns with 2 columns of matching data
    By loritee in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-23-2013, 10:36 AM
  4. Align 3 columns with 2 columns of matching data
    By bearnbillie in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-04-2012, 08:33 AM
  5. Formula to align two columns with nearly similar text and attached numeric columns
    By Benefits Recon in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-27-2012, 12:03 AM
  6. right align columns
    By stermann in forum Excel General
    Replies: 2
    Last Post: 08-15-2007, 06:05 AM
  7. How to align entries in columns so other columns will follow ?
    By Artur in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-07-2005, 04:15 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1