transpose using formula

N

nikos

Hi
I have a column (A1:A100) with numbers and strings. Is there any way to copy
(using formula not copy from menu) these data across a row (lets say F9:DA9) ?
Thank you.
 
G

Gord Dibben

See TRANSPOSE function in help.

Select F9:DA9

In F9 enter = TRANSPOSE(A1:A100)

Note you will use CTRL + SHIFT + ENTER as this is an array function.


Gord Dibben MS Excel MVP
 
R

Rick Rothstein

Perhaps putting this formula...

=INDEX($A$1:$A$100,COLUMN(A1))

in F9 and copying across to DA9 will do what you want.
 
Top