transpose data

[Guest]

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.

 

[Bernie Deitrick]

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

 

[Bernard Liengme]

Have you tried the TRANSPOSE function?
best wishes

 

[Guest]

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 (e-mail address removed). Thanking
you once again.

 

[Bernie Deitrick]

I've sent it out.

HTH,
Bernie
MS Excel MVP

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 (e-mail address removed). Thanking
you once again.

 

[SteveG]

The TRANSPOSE function will work as well.

In your worksheet where you want to have your transposed data, selec
the range where you want your data to appear equal to the number o
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 whoul
look like this afterwards.

{=TRANSPOSE(Your other books range)}

Regards,

Stev

 

[Bernie Deitrick]

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]

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


Thanks

Steve