How to compare the data in row-wise manner between 2 dates for the same element id (Date1 - let say, current date, Date2 - any history date).

[#1]

I have explained the necessary details in the attachment. The output needs to be developed in Pivot table in the same format as in excel.

Thanks in advance

[maxgro]

concat works in this way with your data