This content has been marked as final. Show 3 replies
Please follow the below approach. Sample workbook 10.1 is also attached.
Join both the sheets as shown below:
Create two calculated field and arrange them as shown in snapshot.
Prior and After Data.twbx 30.0 KB
I am glad i could help you.