ExcelBanter - From a series to a matrix

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - From a series to a matrix (https://www.excelbanter.com/excel-programming/426813-series-matrix.html)

Moohwan

From a series to a matrix

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.

All times are GMT +1. The time now is 03:02 AM.