Hi Mike

Try entering in E1
=IF(MOD(ROW(),4)=0,"",INDEX($A:$D,INT(ROW()/4)+1,ROW()-(INT(ROW()/4))*4))
and copy down

--
Regards

Roger Govier


"Mike G" wrote in message
...
Greetings...I have a list of addresses in a1:c20 in the format
a1=name b1=street c1=city state and I want to transpose them into a
vertical alignment with a possible empty row between them. Used
formula =transpose(a1:c20), did f2 and ctrl+shift+enter and result is
value#. any help appreciated.