Prev: Trying to match 1 value to multiple columns
Next: Jpeg links opening in Explorer instead of Picture Manager
From: Gord Dibben on 25 Mar 2010 14:59
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 <Mona(a)discussions.microsoft.com>
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!

From: Ashish Mathur on 25 Mar 2010 21:48
Hi,

Say the cell reference of 1 is B5. In cell B10, type B5 (without the =
sign) and with the fill handle drag this to the right. When you do so, you
will get the cell references instead of values. Now select the array and
press Ctrl+H. In the Find box, type b and replacer with =b

Hope this helps.

--
Regards,

Ashish Mathur
Microsoft Excel MVP

"Mona" <Mona(a)discussions.microsoft.com> wrote in message
news:894B7F0E-4442-499E-A03F-299C36855422(a)microsoft.com...
> 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!

First  |  Prev  | 
Pages: 1 2
Prev: Trying to match 1 value to multiple columns
Next: Jpeg links opening in Explorer instead of Picture Manager