How do I transpose data in columns to rows?
If the data is:

Joe  
some city  
some state  
Bob  
no city  
no state  

… and I use Paste Special » Transpose, I get

Joe some city some state Bob no city no state  

What I want is:

Joe some city some state  
Bob no city no state  

I do not know VBA.

How do I transpose data in columns to rows?

If the data is:

Joe  
some city  
some state  
Bob  
no city  
no state  

and I use Paste Special » Transpose, I get

Joe some city some state Bob no city no state  

What I want is:

Joe some city some state  
Bob no city no state  

I do not know VBA.

how do I transpose columnar data to rows?
If the data is:
Joe
some city
some state
Bob
no city
no state
and I use Paste Special Transpose I get
Joe some city some state Bob no city no state

What I want is:
Joe some city some state
Bob no city no state

I do not know VBA.

Thank you for any help you may be able to give.

How do I transpose data in columns to rows?
If the data is:

Joe  
some city  
some state  
Bob  
no city  
no state  

… and I use Paste Special » Transpose, I get

Joe some city some state Bob no city no state  

What I want is:

Joe some city some state  
Bob no city no state  

I do not know VBA.