You could also try the macro below (or do it manually in a few steps).
I have assumed data in column A, starting at row 2 with results to go beside in columns B:D (but any of that can be changed if required)
From looking at what that data most likely represents, you may actually want those red parts of the code to be "-vs-" and "-h2h-" so change that if required.
Rich (BB code):
With Range("B2:B" & Range("A" & Rows.Count).End(xlUp).Row)
.Value = .Offset(, -1).Value
.Replace "-vs", ";", xlPart
.Replace "h2h", ";", xlPart
.TextToColumns , xlDelimited, , , False, True, False, False, False
Yes, it was your code.
I think it works with Power Query too, but i'm not familiar with that and I didn't know where to input the code.
Again, thanks a lot Peter_SSs.
Also thank you sandy666 for the effort, i really appreciate it.