+ Reply to Thread
Results 1 to 7 of 7

making three columns one, while tripling the number of rows used

  1. #1
    Registered User
    Join Date
    03-28-2013
    Location
    Massachusetts
    MS-Off Ver
    Excel 2010
    Posts
    11

    Question making three columns one, while tripling the number of rows used

    HI,
    I have an issue I need a solution for . I use Excel 2010 and have a 15k row spreadsheet with 3 columns. 1,3,5.
    I need to have the following occur
    Column 1 stays in same position. Column 3 moves under column 1 in next row while the information in the cell is moved down two rows. The column 5 is then moved into the blank cell in column 1.
    So in the example
    A1,A3,A5 and B1 will become A1, B1, C1, and D1

    Can someone please help me as I have to do this for about 15k rows in a spreadsheet. I do have some scripting experience but measure myself as a beginner in VBA.
    Thank you
    Tom Collick

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    27,558

    Re: making three columns one, while tripling the number of rows used

    Hi,

    Can you upload an example workbook which clearly shows a before and after position. It's not clear, at least to me, exactly what you mean.
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    03-28-2013
    Location
    Massachusetts
    MS-Off Ver
    Excel 2010
    Posts
    11

    Re: making three columns one, while tripling the number of rows used

    here is the upload if What I so badly explained.
    Attached Files Attached Files

  4. #4
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    27,558

    Re: making three columns one, while tripling the number of rows used

    In that case why not just add 5 extra rows at the top, copy what was A:E1 (now A6:E6) and paste special transpose back to A1
    Select rows 2,4 & 6 and delete them.

    Encapsulate that in a macro if necessary.

  5. #5
    Forum Guru
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,122

    Re: making three columns one, while tripling the number of rows used

    You have transposed the first three columns in to rows, but not the second one. Are you going to do the same to every other row, i.e., row 1 transposed, row 2 remains the same, then row 3 transposed?
    You said you have 15k rows, but your sample is too small for that size of data, so perhaps you need to increase your sample to see how the data should be formatted.

  6. #6
    Registered User
    Join Date
    03-28-2013
    Location
    Massachusetts
    MS-Off Ver
    Excel 2010
    Posts
    11

    Re: making three columns one, while tripling the number of rows used

    Every row will be made into three rows for all 15k rows to equal 45k rows in one single column.
    I was wondering how to do this easily in Excel.
    thank you,
    Last edited by tomcoll67; 04-01-2013 at 10:28 PM. Reason: add infomration

  7. #7
    Forum Guru
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,122

    Re: making three columns one, while tripling the number of rows used

    It is still not clear to me, neither have not changed your sample , but here we go.

    Please Login or Register  to view this content.
    Last edited by AB33; 04-02-2013 at 04:11 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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