You must validate your TRANSPOSE formula with Ctrl-Shift-Enter since it's an
array formula

HTH
--
AP

"Tim" a écrit dans le message de news:
...
I need to transpose a column to a row without using 'Paste Special'. How do
i
get the second value when using the formula {=transpose(array)}?
tim