Merge row by ID

Discussion in 'Excel Beginners' started by jc.yin, Aug 8, 2013.

  1. jc.yin

    jc.yin Guest

    I've got a set of columns like this in excel:

    ID sizeAndColourAndSku_Value
    2ff0d3d7-8c18-4386-83be-1b2485fb4ea9 Select size
    2ff0d3d7-8c18-4386-83be-1b2485fb4ea9 Extra Small - Available (only
    left)
    2ff0d3d7-8c18-4386-83be-1b2485fb4ea9 Small - Available (only
    left)
    2ff0d3d7-8c18-4386-83be-1b2485fb4ea9 Medium - Available (only
    left)
    2ff0d3d7-8c18-4386-83be-1b2485fb4ea9 Large - Available (only
    left)
    4697ce05-2e50-4e67-85d5-ad733e15ae95 Select size
    4697ce05-2e50-4e67-85d5-ad733e15ae95 6 - Available (only 2 left)
    4697ce05-2e50-4e67-85d5-ad733e15ae95 8 - Available (only 4 left)
    4697ce05-2e50-4e67-85d5-ad733e15ae95 10 - Available (only 6 left)
    4697ce05-2e50-4e67-85d5-ad733e15ae95 12 - Available (only 6 left)
    4697ce05-2e50-4e67-85d5-ad733e15ae95 14 - Available (only 4 left)
    4697ce05-2e50-4e67-85d5-ad733e15ae95 16 - Available (only 2 left)
    4697ce05-2e50-4e67-85d5-ad733e15ae95 Select size


    I need to combine merge them by their ID so the results become lik
    this:

    2ff0d3d7-8c18-4386-83be-1b2485fb4ea9 Extra Small Small Medium
    Large
    4697ce05-2e50-4e67-85d5-ad733e15ae95 6 8 10 12
    14

    I read here that the quickest and easiest way to do this is with a pivo
    table in excel

    http://www.excelbanter.com/showthread.php?t=235727

    However I'm using excel 2010 and the method they've provided doesn'
    really work, anyone able to help me out with this?

    Thank


    --
    jc.yin
     
    jc.yin, Aug 8, 2013
    #1
    1. Advertisements

  2. On Thu, 8 Aug 2013 14:07:43 +0100, jc.yin <> wrote:

    >
    >I've got a set of columns like this in excel:
    >
    >ID sizeAndColourAndSku_Value
    >2ff0d3d7-8c18-4386-83be-1b2485fb4ea9 Select size
    >2ff0d3d7-8c18-4386-83be-1b2485fb4ea9 Extra Small - Available (only 1
    >left)
    >2ff0d3d7-8c18-4386-83be-1b2485fb4ea9 Small - Available (only 2
    >left)
    >2ff0d3d7-8c18-4386-83be-1b2485fb4ea9 Medium - Available (only 2
    >left)
    >2ff0d3d7-8c18-4386-83be-1b2485fb4ea9 Large - Available (only 1
    >left)
    >4697ce05-2e50-4e67-85d5-ad733e15ae95 Select size
    >4697ce05-2e50-4e67-85d5-ad733e15ae95 6 - Available (only 2 left)
    >4697ce05-2e50-4e67-85d5-ad733e15ae95 8 - Available (only 4 left)
    >4697ce05-2e50-4e67-85d5-ad733e15ae95 10 - Available (only 6 left)
    >4697ce05-2e50-4e67-85d5-ad733e15ae95 12 - Available (only 6 left)
    >4697ce05-2e50-4e67-85d5-ad733e15ae95 14 - Available (only 4 left)
    >4697ce05-2e50-4e67-85d5-ad733e15ae95 16 - Available (only 2 left)
    >4697ce05-2e50-4e67-85d5-ad733e15ae95 Select size
    >
    >
    >I need to combine merge them by their ID so the results become like
    >this:
    >
    >2ff0d3d7-8c18-4386-83be-1b2485fb4ea9 Extra Small Small Medium
    >Large
    >4697ce05-2e50-4e67-85d5-ad733e15ae95 6 8 10 12
    >14
    >
    >I read here that the quickest and easiest way to do this is with a pivot
    >table in excel
    >
    >http://www.excelbanter.com/showthread.php?t=235727
    >
    >However I'm using excel 2010 and the method they've provided doesn't
    >really work, anyone able to help me out with this?
    >
    >Thanks


    I do not understand your data or how you obtain your results.
    In particular, your row containing ID ....ea9 in the results seems to be in the same row as the label, with no numbers
    your row containing ID ....ae95 has numbers next to it, but in your source data, there is no indication that these numbers refer to any particular size; and there is no explanation as to why the size 16 is missing.

    Perhaps if you post a workbook, containing a reailistic example of your data source, and desired output, it might be easier for me to figure out what you want. There are many free sharing sites on the WEB. If you have a microsoft hotmail or windows live account, you can use Skydrive.
     
    Ron Rosenfeld, Aug 8, 2013
    #2
    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. bro. Billy
    Replies:
    4
    Views:
    149
    bro. Billy
    Dec 11, 2004
  2. Replies:
    2
    Views:
    108
  3. shanespop2b
    Replies:
    3
    Views:
    126
    gls858
    May 6, 2005
  4. Lynn Bales

    Insert a new row with data from previous row

    Lynn Bales, Aug 8, 2005, in forum: Excel Beginners
    Replies:
    1
    Views:
    96
    Mel Arquiza
    Oct 3, 2005
  5. Rose Davis

    moving every other row up 1 row to the next column

    Rose Davis, Aug 24, 2005, in forum: Excel Beginners
    Replies:
    7
    Views:
    185
    Rose Davis
    Aug 25, 2005
  6. BillBrew
    Replies:
    2
    Views:
    90
    BillBrew
    Mar 15, 2007
  7. Brian Pollard

    Best way to find row number of last row containing data

    Brian Pollard, Jun 18, 2007, in forum: Excel Beginners
    Replies:
    1
    Views:
    118
    Dave Peterson
    Jun 18, 2007
  8. DARKMAN

    calculating row by row

    DARKMAN, Aug 25, 2008, in forum: Excel Beginners
    Replies:
    1
    Views:
    70
    JLatham
    Aug 26, 2008
Loading...