from a series to a matrix using formula

M

Moohwan

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.
 
S

Sheeloo

Enter this in B1
=INDIRECT("A"&(IF(MOD(ROW(),3)=0,3+COLUMN()-2,MOD(ROW(),3) + COLUMN()-2 )))
and copy to B1:D3

You can change 3 to n and copy to nxn cells starting at B1... and having the
required number of row filled in Col A
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Column multiplied by a matrix 2
Arriving at totals 2
From a series to a matrix 0
Adding rota 0
excel copy and paste... 2
How to count the numbers in a Word document? 0
Paragraph numbering in Word 1
How to set a rotating shift schedule for 4 crews with repeat occurrence? -SOLVED 1

Top