JAG836
02-27-2008, 10:33 AM
Hello Everyone,
I am pretty stumped with this, and can't find an answer anywhere. I have a pivot-table set up with a bunch of data. Occasionally some data will appear that looks like this:
HP2AZL160152000 | 62
HP2AZL160152000 | _ _20 16 30
I need to have something that will find when there are duplicates of the item in the left column, and then combine it so that it looks like:
HP2AZL160152000 | 62 20 16 30
Any ideas?
EDIT: Fixed it! Discovered some spaces after some of the duplicates that caused excel to think they were different. Sorry for the needless post
I am pretty stumped with this, and can't find an answer anywhere. I have a pivot-table set up with a bunch of data. Occasionally some data will appear that looks like this:
HP2AZL160152000 | 62
HP2AZL160152000 | _ _20 16 30
I need to have something that will find when there are duplicates of the item in the left column, and then combine it so that it looks like:
HP2AZL160152000 | 62 20 16 30
Any ideas?
EDIT: Fixed it! Discovered some spaces after some of the duplicates that caused excel to think they were different. Sorry for the needless post