Actually I needed both - row to column and column to row, so thanks Biff and
Max. Problem solved!

"Max" wrote:

Think the expression that you posted:
=OFFSET(Sheetname!$A$1,COLUMNS($A:A)-1,)
is for copying across, to transpose dynamically from a column data range

To do it the other way around (your objective here),
ie copy down to transpose dynamically from a row data range
use this in the start cell, copy down:
=OFFSET(Sheetname!$A$1,,ROWS($1:1)-1)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,800 Files:359 Subscribers:56
xdemechanik
---