TRANSPOSE is the easiest way, but if you don't want to use it, you can
use a formula like

=OFFSET($B3,COLUMN()-COLUMN($D$2),0,1,1)

Change $B3 to first cell of the existing data and change $D$2 to the
cell in which you enter this formula. Then copy this formula to the
right through as many columns as you have rows in the original data.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional,
Excel, 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com



On Thu, 25 Mar 2010 10:40:01 -0700, Mona
wrote:

I see lots of post but not one I can use. I am looking for a "function" that
will take vertical data to horizontal. I don't want the copy,paste,
transpose please.

Example :
1
2
3
Results
1 2 3

thanks!