How to use for each with dates

[Marv0Mat]

Hello there,

i have a table like this:

ID	Location	Time
508086-81035-7	52.37787114683906, 9.74037411839534	21.7.21 14:34
508086-81107-4	52.37787114683906, 9.74037411839534	21.7.21 14:34
508086-81107-4	52.37787114683906, 9.74037411839534	21.7.21 14:39
508086-81035-7	52.37787114683906, 9.74037411839534	21.7.21 14:42
508086-81035-7	52.37787114683906, 9.74037411839534	21.7.21 15:08
508086-81035-7	52.37366623982242, 9.790785329629449	21.7.21 14:39

I want to create a for each loop to create a new table with every ID and it's newst Time to get the last location. How am i doing this? thank you in advance!