Link Safe

Make Office Better, we showed you how to use Excel’s ‘transpose’ function see ‘Convert rows to columns in one click’. Transposing a table basically means creating a new table of your original data with rows presented as columns and columns presented as rows. By default, the original and transposed tables are independent of each other changes made to one are not applied to the other.

We’ll show you how to create a transposed table that automatically updates whenever you make changes to the original. First, you need to make a note of the number of rows and columns in your original table. For example, if the table starts at A1 and ends at C7, note down ‘A1:C7’ (it has seven rows and three columns). Next, highlight a blank area in the spreadsheet with the reverse values

of the original table. Using our example, this is three rows and seven columns. In the long formula bar at the top of the spreadsheet (where it says A1=C7). type =(TRANSPOSE(A1=C7)).

Now, instead of pressing Enter (which will transpose your data), press