Post your layout. Is it ALWAYS 3 lines and are there spaces between the
blocks.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Mike Clarke" wrote in message ...
I need to take a single column of names in excel
and have the first line go to column B, the second line to column C the
third line to Column D and than start all over agian. Thus I end up with 3
new columns.
Thx

EggHeadCafe - Software Developer Portal of Choice
Fire and Forget Fun: RPC Pings, GET, POST and more.
http://www.eggheadcafe.com/tutorials...t-fun-rpc.aspx