Hi all, I'm a basic VBAer but this one has me stumped. I basically have a single column of data that I wish to convert to multiple columns.
Any assistance would be greatly appreciated.
Thank you.


From this (1 Column):

Race #13289347
Class*1
3500m
23/02/2022 10:32
3rd
26
Race #13288620
Class*1
3500m
23/02/2022 10:30
11th
Race #13287919
Class*1
3500m
23/02/2022 10:28
3rd
26
Race #13286369
Class*1
4000m
23/02/2022 10:23
6th
Race #13283093
Class*1
3500m
23/02/2022 10:10
11th
Race #13281097
Class*1
4000m
23/02/2022 10:03
6th
Race #13260386
Class*1
3500m
23/02/2022 8:32
2nd
44


To this (6 Columns):

Race #13289347 | Class*1 | 3500m | 23/02/2022 10:32 | 3rd | 26
Race #13260386 | Class*1 | 3500m | 23/02/2022 8:32 | 2nd | 44
Race #13281097 | Class*1 | 4000m | 23/02/2022 10:03 | 6th |
Race #13283093 | Class*1 | 3500m | 23/02/2022 10:10 | 11th |
Race #13286369 | Class*1 | 4000m | 23/02/2022 10:23 | 6th |
Race #13287919 | Class*1 | 3500m | 23/02/2022 10:28 | 3rd | 26
Race #13288620 | Class*1 | 3500m | 23/02/2022 10:30 | 11th |