The Transpose function others have posted is fine for your sample but I'll bet
you have a whole column full of these names and addresses.

If you have, there are better methods than selecting each set and transposing.

Post back if more help needed.


Gord Dibben MS Excel MVP

On Fri, 18 Aug 2006 13:27:02 -0700, USJT wrote:

Name
Address
City
State
ZIp
email
and make it look like

Name Address City State Zip Email