Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 1
Default Merge row by ID

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
  #2   Report Post  
Posted to microsoft.public.excel.newusers
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.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
merge two excel files like in word mail merge azmerritt Excel Discussion (Misc queries) 1 December 11th 16 10:23 PM
Zip codes in mail merge - first digit doesn't display in merge Cheryl Excel Discussion (Misc queries) 1 December 22nd 09 09:13 PM
Mail merge macro: select recipients from Excel during merge Worksmart Excel Programming 0 May 18th 08 06:37 PM
mail merge excludes my headers and critical data in Word merge Nix Excel Discussion (Misc queries) 0 April 21st 06 08:35 PM
Merge =( formula should retain fraction type numbers after merge. Aubrey Excel Worksheet Functions 0 February 9th 06 08:37 PM


All times are GMT +1. The time now is 02:45 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"