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

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

Just the same.
=TRANSPOSE(Sheet1!A1:A2)
--
David Biddulph

"Nick P" <Nick wrote in message
...
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

Transpose should work across sheets just as well
Assume your source data is in Sheet1's B1:D1
In another sheet,
you could array-enter something like this into say, B2:B4
=TRANSPOSE(Sheet1!B1:D1)
Joy? hit YES below
--
Max
Singapore
---
"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