You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Horizontal vs vertical link

Hi All,



When copying a formula across several cell's it normally updates the cell number +1 according to the vertical/horizontal direction. Is there a way to duplicate this behaviour, but doing it from Vertical to Horizontal, like this image?


I would like to only update Data Vertical, and then let Data Horizontal take the updated text, is this possible?



Best...Jan

Posted on Aug 9, 2020 11:48 PM

Reply
Question marked as Top-ranking reply

Posted on Aug 10, 2020 12:41 AM

Can be done with a simple INDEX formula.

Entered in B1 of the second table, then filled right to column J.


If you want to transpose the contents of the whole table, use the Transpose Rows and Columns menu item in the Table menu:


Second table here is a copy of the first.


Selet the second table, then choose Transpose rows and columns from the Table menu.


Row values in the selected table will be placed in columns, Column values will be placed in rows,

Cells will be set to the default width or to fit the content, whichever is wider. Select all column reference tabs, then drag the border between two of the tabs lef to reduce the width.


Regards,

Barry

2 replies
Question marked as Top-ranking reply

Aug 10, 2020 12:41 AM in response to jklarsen

Can be done with a simple INDEX formula.

Entered in B1 of the second table, then filled right to column J.


If you want to transpose the contents of the whole table, use the Transpose Rows and Columns menu item in the Table menu:


Second table here is a copy of the first.


Selet the second table, then choose Transpose rows and columns from the Table menu.


Row values in the selected table will be placed in columns, Column values will be placed in rows,

Cells will be set to the default width or to fit the content, whichever is wider. Select all column reference tabs, then drag the border between two of the tabs lef to reduce the width.


Regards,

Barry

Horizontal vs vertical link

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.