Selecting Only Alpha Characters From Cell 1 And Merge Another Cell?

I have an index of 80,000 names from an index. Some names appear in multiple volumes and on multiple pages within a volume. While the name is the same, they are different people. The Roman numeral is the volume and the numeric is the page number.

Example of original data: Joe Shmoe V-225, 310 VIII-22, 86, 110

I have separated the data into separate columns. Now I have:

Col 1 Col 2 Col 3 Col 4 Col 5 Col 6
Joe Shmoe V-225 310 VIII-22 86 110

At this point, I want to combine the Roman numeral in Col 2 with Col 3 and 4 and combine the Roman numeral in Col 4 with Col 5 and 6.

There are way too many records for me to manually enter the Roman numeral where missing.