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
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
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
Brilliant - Thank you!
Best...Jan
Horizontal vs vertical link
