Using Excel07 ... I've got several thousands of lines like so:

A B C
1: joe blah1 date1
2: date2
3: bob blah2 date1
4: date2

i would like to populate A2 with A1, B2 with B1, A4 with A3, B4 with B3, and
so on ... can I do this systematically instead of manually cutting and
pasting?