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