View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jan Jan is offline
external usenet poster
 
Posts: 5
Default How to in Excel? Do I need a formula for it?

Hello.

I have data in ONE column in every row and would like to have TWO
columns with the same data, but in first column all of the odd rows of
the FIRST column and in the second column all of the even rows of the
FIRST column.
Can someone tell me how to do it?
Thanks for your time and help.
Jan