transpose using formula

  • Thread starter Thread starter nikos
  • Start date Start date
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.
 
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
 
Perhaps putting this formula...

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

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