Array to single column
Dan,
Use this formula in a cell
=INDEX($A$1:$E$5,MOD(ROW()-ROW($A$7)-1,ROWS($A$1:$E$5))+1,INT((ROW()-ROW($A$7)-1)/COLUMNS($A$1:$E$5))+1)
Watch the line wrapping.... Replace the three instances of $A$1:$E$5 with the address of the block
of data, replace the two instances of $A$7 with the address of the cell one row above where you
place this formula (both should be in absolute style - with the $ $ ) and then copy down until you
get an error.
HTH,
Bernie
MS Excel MVP
wrote in message
...
I'm sure this has been discuss before, but It was not quite what I
want to do, I want to go from
A D G J M
B E H K N
C F I L O to
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
newbie excel user, TIA
|