How to transpose linked data and keep it linked?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
TO N HARKAWAT, THANK YOU VERY MUCH!

N Harkawat said:
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
Click to expand...
 
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
 
Back
Top