I need to copy a row of cells from one worksheet to a column of another
worksheet. I want it to reference the cells listed in the row of one
worksheet to the column of the other worksheet. I found out how to do the
reverse - =offset('worksheet name'!$a$1,0,row(1:1)-1) - but it doesn't work
for copying rows to columns? Can you help?