transpose data
 

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.

transpose data
 

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 MVP


"srinivasan" wrote in message
...
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.

transpose data
 

Have you tried the TRANSPOSE function?
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"srinivasan" wrote in message
...
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.

transpose data
 

"Bernie Deitrick" wrote:

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 MVP

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.

transpose data
 

I've sent it out.

HTH,
Bernie
MS Excel MVP


"srinivasan" wrote in message
...


"Bernie Deitrick" wrote:

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 MVP

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.

transpose data
 

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: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=512667

transpose data
 

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 MVP


"SteveG" wrote in message
...


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: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=512667

transpose data
 

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


Thanks

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=512667