Changing field values based on other values in column

Hi, I would like to fill in a column based on the rest of the values in a column?

If there is a value of "Y" in the column I want all the other values to be "N" and if there is a value in the column that is "N" then the rest of the values to be "Y". I understand what i'm trying to do it but trying to iterate over many columns has me stumped. Any help would be appreciated! I've attached a sample that I'm trying to do with sheet 1 being the current set up and and sheet 2 being the desired! Thank you!

Y_or_N.xlsx

Transformation

Accepted answers

AngelosPachis

Hi @AdrianAlt ,

Do you mind giving the following workflow a try? It transposes the data and for each column looks at the available values. If you got "Y" then it will replace the nulls with "N" and vice versa

Hope that helps, let me know if that worked for you.

Cheers,

Angelos

example.yxmd

All comments

AngelosPachis

Hi @AdrianAlt ,

Do you mind giving the following workflow a try? It transposes the data and for each column looks at the available values. If you got "Y" then it will replace the nulls with "N" and vice versa