Easy. In B1 thru D3 enter:

=A1 =A2 =A3
=A2 =A3 =A4
=A3 =A4 =A5

--
Gary''s Student - gsnu2007L


"Moohwan" wrote:

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.