software

Dear community members,
I have to transpose columns in to rows and the data contains about 150
columns. When I use edit/paste special/transpose in to a different worksheet,
the data in the columns changes in to row area. But there is no link to the
original data. When I use paste link option I cannot use transpose as the
option is not available for use. Any idea to convert the columns in to rows
and still should have link to their original source of data so that when ever
I change data in the original work sheet the same is reflected in the
transposed work sheet also. Thank you in advance.
Contact me privately - take out the spaces and change dot to . - and I will send you an Add-in of
mine that allows you to transpose links.

HTH,
Bernie
MS Excel MVPquot;srinivasanquot; gt; wrote in message
...
gt; Dear community members,
gt; I have to transpose columns in to rows and the data contains about 150
gt; columns. When I use edit/paste special/transpose in to a different worksheet,
gt; the data in the columns changes in to row area. But there is no link to the
gt; original data. When I use paste link option I cannot use transpose as the
gt; option is not available for use. Any idea to convert the columns in to rows
gt; and still should have link to their original source of data so that when ever
gt; I change data in the original work sheet the same is reflected in the
gt; transposed work sheet also. Thank you in advance.
gt;
gt;
Have you tried the TRANSPOSE function?
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

quot;srinivasanquot; gt; wrote in message
...
gt; Dear community members,
gt; I have to transpose columns in to rows and the data contains about 150
gt; columns. When I use edit/paste special/transpose in to a different
gt; worksheet,
gt; the data in the columns changes in to row area. But there is no link to
gt; the
gt; original data. When I use paste link option I cannot use transpose as
gt; the
gt; option is not available for use. Any idea to convert the columns in to
gt; rows
gt; and still should have link to their original source of data so that when
gt; ever
gt; I change data in the original work sheet the same is reflected in the
gt; transposed work sheet also. Thank you in advance.
gt;
gt;


quot;Bernie Deitrickquot; wrote:

gt; Contact me privately - take out the spaces and change dot to . - and I will send you an Add-in of
gt; mine that allows you to transpose links.
gt;
gt; HTH,
gt; Bernie
gt; MS Excel MVP
gt;
gt; Dear Mr Bernie
Thanks a lot for your kind response. I am unable to understand how to
contact you privately since no email Id has been given. However I shall be
thankful if you could send the same to my email . Thanking
you once again.
I've sent it out.

HTH,
Bernie
MS Excel MVPquot;srinivasanquot; gt; wrote in message
...
gt;
gt;
gt; quot;Bernie Deitrickquot; wrote:
gt;
gt;gt; Contact me privately - take out the spaces and change dot to . - and I will send you an Add-in of
gt;gt; mine that allows you to transpose links.
gt;gt;
gt;gt; HTH,
gt;gt; Bernie
gt;gt; MS Excel MVP
gt;gt;
gt;gt; Dear Mr Bernie
gt; Thanks a lot for your kind response. I am unable to understand how to
gt; contact you privately since no email Id has been given. However I shall be
gt; thankful if you could send the same to my email . Thanking
gt; you once again.
gt;
gt;

The TRANSPOSE function will work as well.

In your worksheet where you want to have your transposed data, select
the range where you want your data to appear equal to the number of
cells you are transposing and enter the formula:

=TRANSPOSE(Your other books range)

Commit with Ctrl-Shift-Enter as this is an array formula, it whould
look like this afterwards.

{=TRANSPOSE(Your other books range)}

Regards,

Steve--
SteveG
------------------------------------------------------------------------
SteveG's Profile: www.excelforum.com/member.php...foamp;userid=7571
View this thread: www.excelforum.com/showthread...hreadid=512667gt; The TRANSPOSE function will work as well.

Actually, there are a few drawbacks to the TRANPOSE function that links don't suffer from -
primarily, the need to array enter it (which then freezes that block of rows and columns for
insertion/deletion), needing to match range sizes, and the inability to move, copy, or edit
individual cells within the array.

HTH,
Bernie
MS Excel MVPquot;SteveGquot; gt; wrote in message
...
gt;
gt;
gt; In your worksheet where you want to have your transposed data, select
gt; the range where you want your data to appear equal to the number of
gt; cells you are transposing and enter the formula:
gt;
gt; =TRANSPOSE(Your other books range)
gt;
gt; Commit with Ctrl-Shift-Enter as this is an array formula, it whould
gt; look like this afterwards.
gt;
gt; {=TRANSPOSE(Your other books range)}
gt;
gt; Regards,
gt;
gt; Steve
gt;
gt;
gt; --
gt; SteveG
gt; ------------------------------------------------------------------------
gt; SteveG's Profile: www.excelforum.com/member.php...foamp;userid=7571
gt; View this thread: www.excelforum.com/showthread...hreadid=512667
gt;

You are correct. I should make sure to include these types of drawbacks
to warn the potential user.Thanks

Steve--
SteveG
------------------------------------------------------------------------
SteveG's Profile: www.excelforum.com/member.php...foamp;userid=7571
View this thread: www.excelforum.com/showthread...hreadid=512667