View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rod Rod is offline
external usenet poster
 
Posts: 108
Default Auto filling a table of numbers

I have a table as follows and each of the numbers are contained in individual
cells:

1 0 3 0 0 6 0 8
9 0 0 0 13 0 15

I now want to fill another table automatically with the final outcome:

1 3 6 8 9 13 15 again each number in individual cells.

How would I go about achieving this outcome?

Thanks
Rod