Matching field values in different field names

[haribabugv]

Hello Team,

I am trying to concatenate different field names and then find the matching values. I tried using vlookup but i was not successful. Can someone help me out to arrive at the expected output?

For example

Input

Level1	Level2	Level3
Apple	Orange	Strawberry
Banana	Mango	Orange
Mango	Strawberry	Apple

Expected Output

Common	Level1	Level2	Level3
Apple	Yes		Yes
Banana	Yes
Mango	Yes	Yes
Orange		Yes	Yes
Strawberry		Yes	Yes

[uacg0009 · Accepted solution]

Hi Haribabugv,

I think it's what you want:

Thanks.

Aiolos Zhao