transposing data from one table to another - what's it called?

  • Thread starter Thread starter DrummerGirl
  • Start date Start date
D

DrummerGirl

I am trying to take a few colums of data from one table and transpose it
onto another table. However I don't just want to copy and paste, I need
the data in the second table to change if the data in the first one
changes.
I don't know what this function is called, and so therefore I am
finding it very difficult to find out how to do it in the help section
of excel.
If anyone can help me with what this is called, and how to do it, I
will be very grateful
Thank you
Rebecca
 
There are two answers, depending on what you want to do. Suppose we start
with data from A1 thru B10 and we want an "image" from Y1 thru Z10. Select
A1 thru B10 and copy. Then select Y1 and Edit > PasteSpecial > Link


If we want the data transposed (column-to-row), then in Y1 enter:
=INDIRECT("A"&COLUMNS($A1:A1))
and copy across and in Y2 enter:
=INDIRECT("B"&COLUMNS($A2:A2))
and copy across
 
DrummerGirl;2709218 said:
I am trying to take a few colums of data from one table and transpose it
onto another table. However I don't just want to copy and paste, I need
the data in the second table to change if the data in the first one
changes.
I don't know what this function is called, and so therefore I am
finding it very difficult to find out how to do it in the help section
of excel.
If anyone can help me with what this is called, and how to do it, I
will be very grateful
Thank you
Rebecca
Click to expand...


Thanks very much it worked!!
 
Back
Top