Copy data.
Select a cell in destination sheet.
Right clickPasteSpecial check 'Transpose' Hit OK

--
Jacob


"Nick P" wrote:

I understand the =transpose(a1:a2) etc function and to create an array etc -
however I want to copy data from a different work sheet and transpose it but
I can't quite get it to work