Transpose with connection
Solved
Anonymous user
-
michele -
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
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 answers
-
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 ♂
