Macro not needed:
If you data is in column A, then in B1 enter:
=INDIRECT("A" & ROW()*5-6+COLUMN())
Then copy B1 to C1 thru F1.
Then copy B1 thru F1 down as far as you need.
--
Gary's Student
"tbobo" wrote:
I need help with a small program to arrange a data file:
This is the data file:
data
A
B
C
D
data
1
2
3
4
data
D
E
F
G
data
5
6
7
8
I need the data to be arrange as shown below:
data A B C D
data 1 2 3 4
data D E F G
data 5 6 7 8
Thanks!
--
tbobo
------------------------------------------------------------------------
tbobo's Profile: http://www.excelforum.com/member.php...o&userid=31530
View this thread: http://www.excelforum.com/showthread...hreadid=525765