Can you sort on col A-E?
If yes, then you can sort and then enter the formula
=F1&F2
assuming F1 and F2 are in the right order after sorting
in G1 and then copy to G3,G5,,,
Paste special as values... delete rows with blank col G
then delete col F
-------------------------------------
Pl. click ''''Yes'''' if this was helpful...



"TLAngelo" wrote:

I have a spreadsheet where column A has an object ID number and column F has
a title. I would like to combine the titles to make one title if the object
ID numbers are identical. Right now, if there are identical object ID
numbers the title will be contained in sections... for example the first
instance of object ID 139930096 has the first part of the title which is
"Section 3E" and the second instance of object ID 139930096 has the second
part of the title which is "entry wing shop & ESPIS"... it needs to be
"Section 3E entry wing shop & ESPIS". The data in columns B through E will
also be identical like column A, the only column that is different is F.

Is this as clear as mud?!

Thanks for your time,

Tania