Replace Column results with another columns

[ManuelRodrigues]

Hi Team,

I have a column named cost centre and I want to replace the unclassified with the results in the Project cost centre (see image below). I was wondering if a formula tool with if contains function and replace contains function should do the trick but i am struggling to get my head around how this will work? any help will be much appreciated.

Cost Center - Cost center ID	Project Cost Centre
Unclassified	11100LL
Unclassified	11100LL
Unclassified	11100LL
Unclassified	11100LL
Unclassified	1119496
Unclassified	1120082
Unclassified	1120110
Unclassified	1120322
Unclassified	1120348
Unclassified	1120350
Unclassified	1120458
Unclassified	1330114
Unclassified	1330114
Unclassified	1330114
Unclassified	1330114
Unclassified	1330194
Unclassified	1330261

[KarolinaRoza · Accepted solution]

hi @ManuelRodrigues 

did you try Formula Tool applied on Cost Center column with formula:

if ([Cost Center - Cost center ID])="Unclassified" then [Project Cost Centre] else [Cost Center - Cost center ID] endif

regards,

Karolina

[ManuelRodrigues]

@KarolinaRoza thanks for this!