View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jeanne
 
Posts: n/a
Default Selecting every other row to delete or move

I have an imported file that has 12 columns of data in every other row. On
the alternate rows are descriptions that I need to move out of the way of the
12 columns. I need to sum the colums, but the description gets in the way.
See below: I also import a file that has garbage data on every other row, I
would like to be able to select every other row for a range of rows. Any
suggestions greatly appreciated.

A B C D
E
4233 Pay
100 200 300 400 500
4235 Health ins
50 60 70 80
90