Regex question

[Lilydale]

Hi, I've two text files, to combine. 

For book2, how can I deploy Regex to arrange the texts to each respective columns, by texts first then numerical for 16 scores. 

Subsequently, transpose book1 and combined into book2 to assign them with the 16 scores. Thanks. 

[Qiu]

@Lilydale 
I used the regex to bring the data, and not sure the merging you are saying.
I believe you can handle it from there. 😁

[Lilydale]

Thanks Qiu. Tried but got odd results.

Can you show how to join Book1 into Book2. Basically, transpose & replace columns (Score1..) in Book2 for e,g, (1 to Score1, 2 to Score 2, ..etc).