put =A1 in B1, =A2 in C1, =A3 in D1, ...... 1

[daveask]

Hi Experts,

I want to put =A1 in B1, =A2 in C1, =A3 in D1, ......, =A99 in ....
Any idea?

Thank you in advance.

 

[daveask]

Sorry, I want to do that in Excel.

 

[Zathras]

Not sure you can do exactly that without VBA, but this formula gives the same result:
[tt]
=INDIRECT("A"&COLUMN()-1)
[/tt]
Copy it into B1 and then copy from B1 to CV1.

 

[ashmalik]

Thanks Zathras

I am a new member. It is a very useful formula.

Ash

 

[TonyJollans]

.. or ..

Select B1:CV1
Type =TRANSPOSE(A1:A99) in the formula box
Press Ctrl+Shift+Enter

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at VBAExpress[

 

[KenWright]

or....

In say B3 put [A1
In B4 put [A2

select B3:B4 and then drag down and you will get

[A1
[A2
[A3
[A4
[A5 etc

Select all that lot and copy, then select B1 and do Edit / Paste Special / Transpose

Select all new data in row 1 from B1 across, do Edit / Replace and replace [ with =

Delete old data.

Regards
Ken..............


----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
---------------- Click here to help the tsunami victims ----------------

 

[daveask]

Thanks for all your useful helps!!