reversing a column of names

I have a list of 10 to 20 names of Towns on a spredsheet such as:

A B C D
A1 Colton D1 Cajon
A2 San Ber D2 Highgrove
A3 Highgrove D3 San Ber
A4 Cajon D4 Colton
How can I Reverse that Column to another Column
Without re-typing the entire list into the new Column
Any Idea

THANKS BOB

Originally Posted by conductorbob

I have a list of 10 to 20 names of Towns on a spredsheet such as:

A B C D
A1 Colton D1 Cajon
A2 San Ber D2 Highgrove
A3 Highgrove D3 San Ber
A4 Cajon D4 Colton
How can I Reverse that Column to another Column
Without re-typing the entire list into the new Column
Any Idea

THANKS BOB

if you mean to have last name as first and second last as second and so on then try following.
add a new column before that column which has data.
if you have original data in column A insert new column so that data go to column B and you would have column A empty (you can simply copy and paste data from col A to col B to make col A empty).
then in column A put following formula.

=IF(B1<>"",COUNTA(B1:$B$50),"") and copy down.
(range B1:B50 contains your data)

then put following formula in that column where you want to have reversed names.

=VLOOKUP(ROW(A1),$A$1:$B$50,2,FALSE) and copy down until you get #N/A error. above that error will be reversed data.

Regards.