Small Macro

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

tbobo - 23 Mar 2006 18:01 GMT

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

Reply to this Message

Carim - 23 Mar 2006 18:18 GMT

Hi tbobo,

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

HTH
Carim

Reply to this Message

Ardus Petus - 23 Mar 2006 18:35 GMT

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

HTH
--
AP

> I need help with a small program to arrange a data file:
>
[quoted text clipped - 29 lines]
>
> Thanks!

Reply to this Message

Gary''s Student - 23 Mar 2006 18:38 GMT

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.

Signature

Gary's Student

> I need help with a small program to arrange a data file:
>
[quoted text clipped - 29 lines]
>
> Thanks!

Reply to this Message