Create unique IDs to group same values by date

Click here to download a solution from Onedrive
Click here 

How it works ....

Create a table with your test data

Group it

Group it again

Add a custom column

Remove all columns except the custom column

Expand the column

Add a customer column

Remove the unneeded columns and reorder  columns

Please click [thumbs up]  because I hace tried really hard.

And click [accept solution] it it works  .... it clearly does work.
Thank you 😀