Combine if
 

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

Combine if
 

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

Combine if
 

I think I see what you are saying. I was hoping there was a way to not have
to do it all manually each time... my spreadsheet is 1657 rows and there are
quite a few rows that need the title combined.

Tania

"Sheeloo" wrote:

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

Combine if
 

You can record a macro while doing it and rerun it everytime...

If you can logically think of any way this can be done then we can try to
come up with a formula...
If row difference is constant etc...

Also in Excel you can not refer to the cell containing the formula...

-------------------------------------
Pl. click ''''Yes'''' if this was helpful...



"TLAngelo" wrote:

I think I see what you are saying. I was hoping there was a way to not have
to do it all manually each time... my spreadsheet is 1657 rows and there are
quite a few rows that need the title combined.

Tania

"Sheeloo" wrote:

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