maniputating a data array format
Posted by John Howard on December 04, 2001 3:35 AM
Hi,
I would like to manipulate an array of data - 2 columns wide by 301 rows deep i.e. 301 pairs of numbers.
The format I would like to get the 'pairs' of numbers into is 4 pairs wide ( 8 columns) by 75 rows - with the last pair on the 76th row.
hence..
A B
C D
E F
G H
I J
K L etc...
becomes
A B C D E F G H
I J K L etc......
It looks like there should be an easy solution to this, but I can't find it ( other than doing it manually ! )
I'm using Excel 97 SR-1
Regards
John Howard
Posted by Bruno on December 04, 2001 6:59 AM
Hi John, this is a possible solution :
I presume that A1 ="A", B1="B", A2="C", B2="d",...
Step 1 :
In cel C1 you put =A1
D1 =B1
E1 =A2
F1 =B2
G1 =A3
H1 =B3
I1 =A4
J1 =B4
Leave cells C2:J4 blank !
Step 2 :
select C1:J4
Step 3 : copy down untill the end of the list
Step 4 : select column C:J, copy and paste the value's
Step 5 : sort column C:J
Step 6 : delete column A:B
Step 7 : say thank you Bruno ;-)
Bruno
Posted by John on December 05, 2001 3:13 AM
Hi Bruno
Thanks for responding !
Dont quite understand Step 5.
I see that every 4th row of the 'copied data' are the data pairs I want (in the correct sequence)row 1, 5, 9, 13, 17, etc.....
Is there an 'elegant' way to remove the unwanted lines and condense the data - other than permanently deleting the unwanted rows ?
Thanks
John
Posted by Bruno on December 05, 2001 6:15 AM
Re: 'elegant' way to remove the unwanted lines
John,
forget step 6..., but the values are not 'alive' you know what I mean ?
Bruno
