Transposition of data

[Ben.c]

Hi,
I have some data in the column A of a sheet and in another sheet of the same file, I need to use the same data but horizontaly this time : I need that A2 in first sheet come in B1, A3 in C1, A4 in D1...
And I don't want just the data, I need to this to update itself his the first data change. I have try to do in column a of the ne sheet A1 =A1, A2=A2... and the n copy it to do a pastespecial formula-transpose, but it doesn't work...
Thanks for any hel
Happy Christma
Benjamin

 

[Paul]

Hi,
I have some data in the column A of a sheet and in another sheet of the

same file, I need to use the same data but horizontaly this time : I need
that A2 in first sheet come in B1, A3 in C1, A4 in D1....

And I don't want just the data, I need to this to update itself his the

first data change. I have try to do in column a of the ne sheet A1 =A1,
A2=A2... and the n copy it to do a pastespecial formula-transpose, but it
doesn't work....

Thanks for any help
Happy Christmas
Benjamin

Let us say your data in column A is in Sheet1 and you want the results in
row 1 of Sheet2.
In Sheet2!A1 put this formula:
=OFFSET(Sheet1!$A$1,COLUMN()-1,0)
Copy this formula across to B1, C1, D1, E1... as far as needed.

 

[Ben.c]

Thanks a lot for the answer Paul..
Sorry to have post the question on different newsgroup I thought it was different persons in each
Merry christmas and Happy new yea