View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Moohwan Moohwan is offline
external usenet poster
 
Posts: 3
Default from a series to a matrix using formula

Hi.
Suppose I have a series of observations.
1
3
5
7
9

My objective is that I want to have the following matrix.
1 3 5
3 5 7
5 7 9

How could I accomplish this work?
Any help would be appreciated.
thanks a lot in advance.