Could you please upload a file that contains the raw data? That makes it easier to come up with a solution. Thank you!

Hello Riny,

Attached is the raw data file. Alistair

Thanks for the file. Just wondering how you would know which month we are dealing with. Obviously, your example relates to January as that is what is written in the Sheet name. Will you always receive csv files with the name of the month in it?

And just to be sure, a time reference like 8.3 will be thirty minutes past 8, whereas 10.05 will be 5 minutes past 10. Correct?

Hi Riny,

https://www.trggpattaya.com/schedule/

This is the link to the webpage. The new month is added to the website each month and identified only by the title January 2023, February 2023 etc

Time references are displayed on website as 08.30 10.05 etc. Importing them truncates zeros so 08:30 becomes 8.3

The file Raw Data I loaded it without transforming anything.

Thanks
Alistair

Hi Alistair,

Did a quick-and-dirty query that does what you need, I believe. I made no attempts to make it look nice, but the steps aren't difficult to follow. It should also work when February is added to the web-site.

See if it works for you.

Riny

Hi Riny,

Thanks for your work on this much appreciated. I've downloaded and will analyse the steps to understand how you transformed it.

Kind regards

Aistair