Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Combine cells with the same reference and combine quantities | Excel Discussion (Misc queries) | |||
combine or if | Excel Worksheet Functions | |||
how to combine........ | Excel Discussion (Misc queries) | |||
How Can i combine | Excel Discussion (Misc queries) | |||
Combine into one please. | Excel Worksheet Functions |