Dear Experts

Table1 has two character type fields as
name c(40)
country c(40).

Data in fields is as follows

Mike England
Eric France
Robert Germany
(3 records)

I want to append second field's data into first field, new row, as

Mike
England
Eric
France
Robert
Germany
(6 records)

What command should I use to create a cursor?

Please help