there is date field in a row but Date is required as a column. i have attached sampledata

[irfanchoudhry]

Input data and required output is mentioned inside the file

[aatalai · Accepted solution]

@irfanchoudhry the attached workflow does the trick, let me know how you get on

[irfanchoudhry · Accepted solution]

Thanks you very much. it is exactly what i was looking