Data is in A1:A10

Select B1:K1 and enter =TRANSPOSE(A1:A10)

Hit CTRL + SHIFT + ENTER

But.............much easier using OFFSET or INDIRECT as others have posted.





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!