Multiple Yes/No Fields Into one Field

[Matt_Mohawk]

Hi,

I have a table that has 4 yes/no fields. I would like to combine these fields into one field and if they have Yes in the cell then I would like for the value to be the field name that is being merged. For example if International (Y/N) is showing Y on a row then I would like for the new merged column to say International (Y/N) instead of Y. See image below.

[Matt_Mohawk]

Thanks @johnt75,

I didn't think it was something that simple lol.

Thanks again!

[johnt75 · Accepted solution]

In Power Query go to the Add Column section and choose Conditional Column. You can add clauses looking at the different columns and set the value accordingly