Thread: Merge row by ID
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Ron Rosenfeld[_2_] Ron Rosenfeld[_2_] is offline
external usenet poster
 
Posts: 1,045
Default Merge row by ID

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.