+ Reply to Thread
Results 1 to 4 of 4

Make three columns into one big one

  1. #1
    Registered User
    Join Date
    12-18-2008
    Location
    Bolivia
    Posts
    42

    Question Make three columns into one big one

    Hey everyone!

    I would like to join (i am not even sure "join" would be the appropriate word) three columns of data into one big column. You can take a look at my file, basically I have A, B, and C columns with 10 entries (rows) each one. Basically I want them all to be one large column with 30 rows (starting first with values from column A, then B, then C).

    Thank you very much for the help!



    ORLANDO
    Attached Files Attached Files
    ________________________
    Orlando Nunez B., M.S.
    Project Engineer
    IASA Construction Company
    Santa Cruz - Bolivia

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland... but I could be anywhere in the world
    MS-Off Ver
    Office 365 for PC.
    Posts
    35,539

    Re: Make three columns into one big one

    Try this:

    =IFERROR(INDEX($A$1:$C$10,MOD(ROWS($1:1)-1,10)+1,INT((ROWS($1:1)-1)/10)+1),"")
    Glenn



  3. #3
    Registered User
    Join Date
    12-18-2008
    Location
    Bolivia
    Posts
    42

    Re: Make three columns into one big one

    Amazing thank you!!!

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland... but I could be anywhere in the world
    MS-Off Ver
    Office 365 for PC.
    Posts
    35,539

    Re: Make three columns into one big one

    You're welcome and thanks for the Rep.

+ 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. Make stacked columns into one row
    By FrazierLoans in forum Excel General
    Replies: 5
    Last Post: 12-07-2013, 04:09 PM
  2. How to make code look in other columns
    By Spark9871 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-06-2013, 03:56 PM
  3. [SOLVED] make new columns from copying values from other columns
    By lenorsk in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-18-2012, 10:55 AM
  4. [SOLVED] Excel 2007 : How to Make Two Columns into Two Rows?
    By Gnokrojam in forum Excel General
    Replies: 3
    Last Post: 03-02-2012, 05:05 AM
  5. How to make it 'prioritize' between columns?
    By banestyrelsen in forum Excel General
    Replies: 6
    Last Post: 03-24-2008, 03:46 PM
  6. trying to take rows and make them into columns
    By klobes01 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-01-2007, 03:47 PM
  7. [SOLVED] How do I make the A,B,C... on top of the columns hidden?
    By briana in forum Excel General
    Replies: 2
    Last Post: 07-26-2005, 04:05 PM
  8. Make columns
    By Michael in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-03-2005, 03:06 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1