View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave O[_2_] Dave O[_2_] is offline
external usenet poster
 
Posts: 19
Default Rearranging data in one column into two columns

This formula worked for me:
=OFFSET($A$1,(ROW()*2)-2,0,1,1)+OFFSET($A$1,(ROW()*2)-1,0,1,1)

For this formula to work, it must start on the same row that your
"present data" range starts. Where the formula says "$A$1", enter the
address of the cell that starts the present data range. Also, the
formula assumes recognizes the entries as dates and times (not text,
for instance); format the formula cells as date/time.

Dave O