Combine results of two columns into one Lookupvalue

[Anonymous]

Dear Community,

the goal is to write a new calculated column which combine results of two other columns.

I describe the logic for understanding:

my table contains employee numbers and names of the respective supervisor of an employee.

There are two further columns in this table for a supervisor of an employee number, which cannot both be filled at the same time.

I want to enter the name of the supervisor in a new column per lookupvalue for each employee number.

Example:

Employee Number	Supervisor_A	Supervisor_B
1	Simon	null
2	null	Tom
3	null	Brad

You can see that only one supervisor column is filled, A or B.

So in my new calculated column I want to lookupvalue for employee 1 in the column supervisor_A and write Simon in it, but for employee 2 and 3 I want to look in the column supervisor_B and write Tom and Brad respectively.

Thank you for your support.

[tamerj1 · Accepted solution]

Hi @Anonymous 
What would you do if both names are available? As per current sample, simply concatenate

Supervisor =
TableName[Supervisor_A] & TableName[Supervisor_B]

 both names