Re: Need to reorganize - transpose columns to rows per article number

Discussion in 'Microsoft Excel Misc' started by zvkmpw, Aug 19, 2012.

  1. zvkmpw

    zvkmpw Guest

    On Thursday, August 16, 2012 1:16:18 PM UTC-7, toblju wrote:
    > I have a list with five columns. Every row contains following data:
    >
    > Article Info 1 Info 2 Info 3 Info 4
    > 500086 black blue white yellow
    > 500087 black red blue green
    >
    > I would like it to look like this:
    >
    > Article Number Info
    > 500086 1 black
    > 500086 2 blue
    > 500086 3 white
    > 500086 4 yellow
    > 500087 1 black
    > 500087 2 red
    > 500087 3 blue
    > 500087 4 green


    With the source date in Sheet1, put the following in Sheet2.

    In A2
    =INDEX(Sheet1!A:A,INT((ROW()+2)/4)+1)

    In B2
    =MOD(ROW()-2,4)+1

    In C2
    =INDEX(Sheet1!$B:$E,INT((ROW()+2)/4)+1,MOD(ROW()-2,4)+1)

    Copy A2:C2 down as far as needed.

    Put the column headers in row 1.

    Hope this helps getting started.
     
    zvkmpw, Aug 19, 2012
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. sallyember
    Replies:
    1
    Views:
    246
    Frank Kabel
    May 17, 2004
  2. Guest

    Reorganize excel listing

    Guest, Jul 2, 2004, in forum: Microsoft Excel Misc
    Replies:
    1
    Views:
    176
    Debra Dalgleish
    Jul 2, 2004
  3. Guest

    Reorganize list

    Guest, Apr 1, 2005, in forum: Microsoft Excel Misc
    Replies:
    2
    Views:
    152
    Guest
    Apr 5, 2005
  4. Guest

    Reorganize Data

    Guest, Jan 24, 2007, in forum: Microsoft Excel Misc
    Replies:
    2
    Views:
    200
  5. toblju
    Replies:
    1
    Views:
    324
    toblju
    Aug 16, 2012
Loading...

Share This Page