Combining fields together

[adnil]

We have the following fields in a table:

Team name Year ID Figure
ABC 2015 0
ABC 2014 160
ABC 2013 160

XYZ 2015 172
XYZ 2014 0
XYZ 2013 0

ABC was the team's old name and XYZ is the team's current new name. We would like to data to appear as:

XYZ 2015 172
XYZ 2014 160
XYZ 2013 160

Any suggestions on how we can achieve this please?

Thank you.

Lin

 

[Charliy]

if {table.field} = 'ABC'
then "XYZ"
else {table.field}

 

[adnil]

Thank you Charliy

Lin