Help with multi-column formula

[wy_403411]

I have some price data (~40million rows) and I want to know when the price changes. The data looks like this. 

Each row represents an item sold at a particular store, and each column represents the price of that item if a transaction has occurred. The empty cells suggest that there is no transaction for that item at that store in that month. 

I want to know highlight the months that an item changes the price for each store. For example, if the price is different from the prior non-null column, then "Yes". If the price is the same or empty, then "No" price change. 

Is there a way to do this in Alteryx? 

Thanks! 

[Drussek · Accepted solution]

I think it will do the job.

[wy_403411]

Worked like magic. Thank you very much! 

[Drussek · Accepted solution]

@wy_403411 take a look at 2 alternatives I've prepared.

They may be faster, which is not insignificant with 40 million rows.

Good luck!

[wy_403411]

Thank you very much! Both worked well for my task! 

Much appreciated.