convert vertical to horizontal (without Transpose)

[timtim89]

Hey there,

I suppose im looking for an Indirect function for this, but cant figure it out. I want to be able to pull a function sideways and get vertical cell values from an area. Say I type in the function in B1, referencing it to A1, and pull to D1. Then I would have A1 value in B1, A2 in C1 and A3 in D1. Anyone who can supply me with a formula?

Thanks a lot in advance!

[Dennis7849]

Can you attach a sample of what you are proposing?

[Søren Larsen]

Here you go; I think!?

[ChemistB]

One way

=INDEX($A$1:$A$50,COLUMN(A1))
Does that work for you?

Another way
=INDIRECT("A"&COLUMN(A1))

I'd use the first.

[timtim89]

Here is the attachment.

[ChemistB]

IF you plan on dragging the formula out further than the values in A (or in C in your attachment), you can nest the formula in an IF statement like so

=IF(COUNT($A:$A)>=COLUMN(A1), INDEX($A$1:$A$50,COLUMN(A1)), "")

Edit, had my arguments backwards

[timtim89]

ChemistB that's exactly it! Thanks to all of you for the quick replies