Transpose Varying Colums

You are welcome.

I've realised this this actually swaps the Day and Month in the date. I've traced through the code and found that it transposes correctly but when it runs the TextToColumns it swaps the date and month. Any help is greatly appreciated. Thanks.


From:
Race #20863804
Class*1
3500m
10/03/2022 11:09
1st
105

To:
Race #20863804 Class*1 3500m 3/10/2022 11:09 1st 105