Combining paste functions: Paste Link and Transpose

[Jesse]

Anyone able to do this? Choosing "transpose" in the Paste Special menu grays out the Paste Link option.


AND/OR


I have a reasonable array of cells (~15 rows x 24 cols), populated by a conditional reference to another cell:

=IF(C6="", "", C6)

- I want to transpose paste this option, but 1) you can only transpose-paste with Copy, not Paste, and 2) when I transpose paste a copied version, it doesn't work because the references are relative.


Any ideas? Am I missing something simple?


Thanks in advance.

 

[Faseeh]

Hi Jesse,


I just tried that twice and it is not working. I think you can use Transpose() instead, that will too have cells connected and transposed as well. (but a little bit of manual work).


Regards,

Faseeh

 

[Debraj]

Hi Jesse,


* Copy the cells.. (Z5 to AM16)

* select V24.

* Press (Alt + E + S + V + E + Enter)

Paste Special > Values & Transpose.


If any option is with Radio Button only then, you don't have option to choose multiple option, but if you combined it with CheckBox, then you have multiple option.


BTW.. Narayan already did the same by formula..


@ Faseeh.


Can you please close this post.


as we already have one here..

http://chandoo.org/forums/topic/transpose-table-from-a-questionnaire


Regards,

Deb


EDIT:


@Debraj Roy

Hi!

You ask it, you get it.

Regards!


@Faseeh

Hi!

It was he who asked...

Regards!