Identify Changes in Data each Month

[DelData]

Can you help?

Each month i get a data file called change tracker sample.xlsx as shown by attachment and by master data.png

Columns A & B are fixed, Order ID and Order Date, but the number of columns to check for changes could change from 7 in this example to be >7 or <7 depending on how data changes over time

The order date column gets updated each month and i need to capture any changes each month

 

The change highlight.png shows 16 changes highlighted in red that have changed over the 9 different order dates

What i am after is the shown in the output required.png below which captures what has changed each month, under Property in Column B, and what the old and new value is and when this change happened, change date...which is the order date...

Any help would be great :)

[Raj]

@DelData 
find the workflow attached
mark done if solved.

[DelData]

thanks Raj ...this is excellent and very close to what i after....if i take ES-2024-222222 as example the green ticks are correct but the red crosses are wrong....if you have time please could you help update your workflow please to fix....each order id has its unique order date...the first order date per order id should not be marked as a change since it is the first record for the order id 

 

[Raj · Accepted solution]

@DelData 
updated Mark done if solved.

[DelData]

Fantastic....it works perfectly....thanks Raj.......great help and solution😀