View original (French)

Transpose with connection

Solved
RachelMartel Posted messages 460 Status Membre -  
 michele -
Hello,

I have a sheet 1 with formulas arranged horizontally, all on the same line. On my sheet 2, I would like to display them vertically and with links. I wanted to do a copy-paste with transposition and linking, but when we transpose, the link option is no longer available.

Do you have a solution? :)

Thank you in advance!

Configuration: Windows 7 / Chrome 30.0.1599.101

3 réponses

Réponse 1 / 3
Raymond PENTIER Posted messages 58546 Registration date   Status Contributeur Last intervention   17 474
 
Hi, Rachel.

* In Sheet2, select A1:A6
* type =TRANSPOSE(Sheet1!B4:G4)
* confirm with CTRL+SHIFT+ENTER to obtain an array formula, which will display in the formula bar as -> {=TRANSPOSE(Sheet1!B4:G4)}
It is identical in all 6 cells -> https://www.cjoint.com/?CJygDJdxdz3

You have detailed explanations in my technical sheet
https://forums.commentcamarche.net/forum/affich-37641895-excel-transposer-lignes-colonnes

Best regards.
Retirement is nice! Especially in the Caribbean... :-)
☻ Raymond ♂
9
RachelMartel Posted messages 460 Status Membre 25
 
Once again, it's great!

Thank you very much, it answers my question very well!
0
michele
 
Excellent, thank you very much.
0