If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Transposition of data
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 |
#2
|
|||
|
|||
Transposition of data
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 year |
Thread Tools | |
Display Modes | |
|
|