Prev: Trying to match 1 value to multiple columns
Next: Jpeg links opening in Explorer instead of Picture Manager
From: Mona on 25 Mar 2010 13:40
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: Eduardo on 25 Mar 2010 13:46
Hi,
Highlight the range, copy,paste special, transpose

"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!
From: Mike H on 25 Mar 2010 13:48
Hi,

If your data start in a1 put this in a cell and drag right

=INDIRECT("A"&COLUMN(A1))
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"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!
From: Luke M on 25 Mar 2010 13:48
OP specifically said they didn't want to do that.

Assuming your data starts in A2:
=OFFSET($A$2,COLUMN(A1)-1,)

Copything this across will accomplish your goal.

--
Best Regards,

Luke M
"Eduardo" <Eduardo(a)discussions.microsoft.com> wrote in message
news:CA5B3102-53A6-4B4F-BE59-65A056B1ECD3(a)microsoft.com...
> Hi,
> Highlight the range, copy,paste special, transpose
>
> "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!


From: Chip Pearson on 25 Mar 2010 14:11
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
<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!
 |  Next  |  Last
Pages: 1 2
Prev: Trying to match 1 value to multiple columns
Next: Jpeg links opening in Explorer instead of Picture Manager