Division of Data Columns?
=OFFSET($A$1,ROWS($1:1)*2-2+MOD(COLUMNS($A:A)+1,2),INT((COLUMNS($A:A)-1)/2))
and copy across your required 6 columns and down as far as required.
I am assuming that your data values continue in the following order:
A C E
B D F
G I K
H J L
M O Q
N P R
--
David Biddulph
"Stevie" wrote in message
...
I have an old file that is set up in three columns like so:
A C E
B D F
I need the data in six columns: A B C D E F in order to sort, etc.
Anyone know how I can do this easily? There are about 1000 lines of data
so
cutting & pasting individually is out of the question.
|