Convert long line into multiple rows

Data -> Text to columns -> Delimited -> Next -> Choose ; in other box -> Finish

After that select that row and copy -> paste spetial -> check Transpose box -> OK

If on the off-chance this is something you need to do repeatedly you could use sub routine such as:

Please Login or Register  to view this content.

The above would take contents of A1, split based on ; delimiter and transpose to A1:Ax