Oops, think the formula given* was an overkill <g

This shorter one suffices for the purpose:

Put in A1:

=OFFSET(secondaryworksheet!$A$1,COLUMNS($A$1:A1)-1,)

Copy A1 across as many cols as you have rows to extract from
"secondaryworksheet".

*It's meant for copying across and down to transpose what's in
"secondaryworksheet".

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----