Transform Data from from one Excel Sheet into another

Good evening everyone,
I would again ask you on how to create a table from raw Data in Excel Sheet TestList, so that the output looks like in Excel Sheet OutputList(added manually). How many restarts for that atm happened on that date.
list.xlsx (10.7 KB)

The amazing Toshio helped me twice. I tried it myself but I’m simply having difficulties with Linq.
Again thank you very much.

Hi,

How about the following sample?

Sample20240528-1a.zip (12.0 KB)

Regards,

1 Like

As always, you are amazing.
I’m ashamed that I never could done this alone.
Thank you for your help.

Best regards,

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.