transpose links from a column to a row
 

I have a lsi of data ina column and need to transpose it into a row without
'Paste Special'. The array fromula of {=transpose(array)} doesn't ssem to
work. I have used this, i get the frist value, but am not sure how to get the
second value.
tim