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

--
tbob
-----------------------------------------------------------------------
tbobo's Profile: http://www.excelforum.com/member.php...fo&userid=3153
View this thread: http://www.excelforum.com/showthread.php?threadid=52576

Hi tbobo,

You dont need a macro ...
Just Edit Copy
Edit PasteSpecial Transpose

HTH
Carim

This can be done with a formula.
See example: http://cjoint.com/?dxsKNTriB0

HTH
--
AP

"tbobo" a écrit dans le
message de ...

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

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