I have a column (departments) in my table that has 4 different values: (department1, department2, department3 or department4). What I would like to do is transform the text to something else depending on a criteria to make it easier to understand.

So very simply put:

```
IF departments = "department1" then re-write department1 as Finance
IF departments = "department2" then re-write department2 as HR
IF departments = "department3" then re-write department2 as Service
etc...

```

Then the departments column would go from looking like this:

```
departments
-----------
department1
department1
department3
department1
etc..

```

to 

```
departments
-----------
Finance
Finance
Service
Finance
etc..

```

I've been searching for a long time now and couldn't find any way to do it, I'm not even sure if it's possible at all. Apologies if this has been asked before.