Formula tool with multiple expressions validating multiple columns

[EricMartinson]

Hello,

I am comparing data from two versions of the same report to identify the differences so I know which records have columns that need to be corrected. I am using a Formula tool with eight expressions to validate four sets of data and arrange the output messages. This solution works but I have two questions.

1. Is there a more efficient way I could have done this?
2. This formula tool is only validating January data but I need to do the same for all other months. Is there a way to dynamically run for all the other months without recreating this same formula tool for each specific month?

[JarekSkudrzyk · Accepted solution]

@EricMartinson 

hi,

you can transpose the data and then compare a single column - i think it is quicker (my solution attached).

[EricMartinson]

Thank you @JarekSkudrzyk! This approach worked perfectly. 

[JarekSkudrzyk]

@EricMartinson you are welcome, glad I could help!