Results 1 to 8 of 8

Converting Columns to Rows using a Loop

Threaded View

  1. #1
    Registered User
    Join Date
    08-05-2009
    Location
    Sussex, NJ
    MS-Off Ver
    Excel 2003
    Posts
    2

    Arrow Converting Columns to Rows using a Loop

    I have a table with 25 columns and 2000+ records. Columns 2 through 25 are different values for the first column. I need to keep column 1 as column 1, but make columns 2-25 as column 2 Row 1, Column 2 Row 2, Column 2 Row 3, etc. and then start with the next record once Column 26 is reached. I may have blank cells in the columns so I cannot stop the loop when the field is blank. I have attached a sample of what I am trying to accomplish and am hoping that someone can understand what I wrote.

    Thank you for your help!

    Original Data

    Clothing Color1 Color2 Color3 Color4 Color5
    Shirt Red Yellow Blue Green Orange
    Pants Yellow Blue Green Orange Red
    Hat Blue Green Orange Red Yellow
    Scarf Green Orange Red Yellow Blue


    I need it to look like this:

    Clothing Color
    Shirt Red
    Shirt Yellow
    Shirt Blue
    Shirt Green
    Shirt Orange
    Pants Yellow
    Pants Blue
    Pants Green
    Pants Orange
    Pants Red
    Last edited by DHazen; 08-05-2009 at 07:50 PM.

Thread Information

Users Browsing this Thread

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

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