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

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




--
DrummerGirl

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

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

--
Gary''s Student - gsnu2007g


"DrummerGirl" wrote:


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




--
DrummerGirl

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

DrummerGirl;2709218 Wrote:
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


Thanks very much it worked!!




--
DrummerGirl