Small Macro

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!

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

HTH
--
AP

"tbobo" <tbobo.254u2m_1143133807.2189@excelforum-nospam.com> a écrit dans le
message de news:tbobo.254u2m_1143133807.2189@excelforum-nospam.com...
>
> 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
>
>