Good morning @Chirag1991,
the only difference between your output and mine, are the dates and the number of columns. My workflow considered the same date, and you only need to add the filter to each unique date, inside the for each.
→ This can be done with the Filter DataTable activity, or with LINQ, as you prefer.
You only need to add this extra filter, and for each date, get your new row based on the filtered result. And remove the unwanted rows before typing it back to the output sheet.
Please remember that the forum is used to provide support, and we will not normally develop full functional workflows as per request.
→ Feel free to reuse any components on the actual workflow, to make that extra filter, and you’ll have your desired output.