You posted to a programming newsgroup, so I presume you will want a VBA
solution. How is your program to read in the "series of observations"...
from a worksheet row or column, type in by the user, some other way? Where
do you want the "matrix" at... in an array within your program, placed on a
worksheet somewhere, somewhere else? Is the number of "columns" in your
matrix always going to be 3, or is that something you want the program to
get from the user (and, if so, how)? The more details you provide when
asking a question, the better chance you will have of getting your question
answered in a way you can use.

--
Rick (MVP - Excel)


"Moohwan" wrote in message
...
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.