I have a string of names and surnames:

Name1 Surname1 Name2 Surname2 Name3 Surname3

and I want to transform it into separate columns like this:

I have tried Paste formatting -> Split text with a space separator and then Paste special -> Transposed, but it separates the first and last name into different columns (columns 6-11):

I have also found