Delimited Data - Columns and Rows

Difficult to be concise without an actual sample of the data. If I copy the data from your post, I get new line characters rather than paragraph marks in MS Word.

So, what I would do, is (global) replace all the new line characters (^l) with a comma (,). I would then (global) replace all the semi-colons followed by a comma (;,) by a paragraph mark (^p).

That should give you your data with each field separated by a comma and each record separated by a paragraph mark

You may have an extra blank record at the beginning which you can ignore. And you may have an extra comma/field on the end of each record which you can ignore.

Having done that, you can copy and paste the data from Word into Excel.

Then use Text to Columns, comma delimited to split it into separate columns.