Re: How to transpose linked data and keep it linked?
- From: "N Harkawat" <nharkawat@hotmail_dot_com>
- Date: Tue, 14 Jun 2005 11:57:29 -0400
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" <Amy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:EB98BF15-F723-4AAE-B86D-4D775F8CA847@xxxxxxxxxxxxxxxx
> 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
>
.
- Follow-Ups:
- References:
- Prev by Date: OFFSET command and linked documents
- Next by Date: Can I create a formula in Excel that evaluates form information?
- Previous by thread: How to transpose linked data and keep it linked?
- Next by thread: Re: How to transpose linked data and keep it linked?
- Index(es):
Relevant Pages
|
