Forum Discussion
Solved
Multiple Yes/No Fields Into one Field
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.
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
2 Replies
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
