How to transpose linked data and keep it linked?
 

Is it possible to have data transposed and still be linked to my original
data. As far as I can tell it can only be pasted out as values, and lose the
link.
Thanks for any help
PS the simpler the better :)

Amy

select the range that you want to have your data transposed
Say you want 10 Rows and 3 columns
then select 3 rows and 10 columns
say you wan the range A1:C10 transposed to F1:O3

after selecting F1 thru O3 type
=transpose(A1:c10)
and hit Ctrl+shift+enter

you data is now transposed and linked


"Amy" wrote in message
...
Is it possible to have data transposed and still be linked to my original
data. As far as I can tell it can only be pasted out as values, and lose
the
link.
Thanks for any help
PS the simpler the better :)

Amy

TO N HARKAWAT, THANK YOU VERY MUCH!

"N Harkawat" wrote:

select the range that you want to have your data transposed
Say you want 10 Rows and 3 columns
then select 3 rows and 10 columns
say you wan the range A1:C10 transposed to F1:O3

after selecting F1 thru O3 type
=transpose(A1:c10)
and hit Ctrl+shift+enter

you data is now transposed and linked


"Amy" wrote in message
...
Is it possible to have data transposed and still be linked to my original
data. As far as I can tell it can only be pasted out as values, and lose
the
link.
Thanks for any help
PS the simpler the better :)

Amy

How to transpose linked data and keep it linked?
 

i tried this but i am getting a messaeg that there is a circular referecens
which cannot be displasyed. in which cell exactly do i need to type the
transpoe formula? thanks so much


"N Harkawat" wrote:

select the range that you want to have your data transposed
Say you want 10 Rows and 3 columns
then select 3 rows and 10 columns
say you wan the range A1:C10 transposed to F1:O3

after selecting F1 thru O3 type
=transpose(A1:c10)
and hit Ctrl+shift+enter

you data is now transposed and linked


"Amy" wrote in message
...
Is it possible to have data transposed and still be linked to my original
data. As far as I can tell it can only be pasted out as values, and lose
the
link.
Thanks for any help
PS the simpler the better :)

Amy