View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
JayPee JayPee is offline
external usenet poster
 
Posts: 12
Default How do I tackle this problem?

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

A B C
row1 joe blah1 date1
row2 date2
row3 bob blah2 date1
row4 date2

i would like to populate A2 with A1, B2 with B1, A4 with A3, B4 with B3, and
so on ...