Changing field values based on other values in column

[AdrianAlt]

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!

[AngelosPachis · Accepted solution]

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

[mceleavey]

Hi @AdrianAlt ,

just a bit of transpose and cross-tab magic:

M.

[Luke_C]

Here's one approach with the dynamic replace tool: 

[AdrianAlt]

Thanks @AngelosPachis that seems to have done the trick!