Hi Rodrigo

Copy A1:A4, move cursor to C1, Paste SpecialTranspose
In cell C2 enter
=OFFSET($B$1,((ROW()-2)*4)+(COLUMN()-3),0)
copy across through D2:F2
Copy C2:F2 down as far as required
--
Regards

Roger Govier


"Rodrigo Ferreira" wrote in message
...
I have a list (something like this):

aaa=2
ddd=3
ttt=4
ooo=6
aaa=4
ddd=5
ttt=6
ooo=7
aaa=3
ddd=5
ttt=7
ooo=3
...

And I wanto to make something like this

aaa ddd ttt ooo
2 3 4 6
4 5 6 7
3 5 7 3
...

how can I do this?


Rodrigo Ferreira