One way if you need the transpose to be dynamic to source
Assuming source table is in Sheet1's A1:E5
In another sheet,
Place in A1: =OFFSET(Sheet1!$A$1,COLUMN()-1,ROW()-1)
Copy A1 across / fill down to E5 to return the required transpose
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Elaine" wrote:
I have some data that shows how college students are doing over 4 years.
However, when I try to get cohort data, I am finding it difficult to extract
the data I require. I hope that this question makes sense and someone can
help me.

The data is organized this way:

Table 1
2000 2001 2002 2003
Fresh 78 78.2 81 78.5
Soph 68 70 70.7 79
Jun 73 54 70 65.5
Senior 77 73 54 69


In order to graph the cohort data I would like the data this way:

Table 2

Fresh Soph Jun Senior
2000 78 70 70 69
2001 78.2 70.7 65.5
2002 81 79
2003 78.5

The data has a longer string but I hope that you get the gist of what I am
doing.

I have Table 1 but don't have Table 2. Can someone please tell me how I can
get Table 2 without having to manually type in Table 2 "=B2" etc. I tried to
use the Index function but no dice. Any help would be greatly appreciated.
Thank you.