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