I'm currently helping a colleague migrate data from one database to another, but am having difficulty in the process.

The data in question currently in a word document and each database entry in 10 lines of text, separated by a semi-colon and then another 10 lines i.e.

;
1
2
3
4
5
6
7
8
9
10
;
1
2
3
etc

I'm trying to place this into an excel file in the following format:

1 2 3 4 5 6 7 8 9 10
1 2 3 4 5 6 7 8 9 10
etc.

Because I believe I'm essentially delimiting by two separate values, I'm unsure how to make this happen.

Any help would be greatly appreciated. (Also happy to provide more information if this was unclear at all)

Arch