you can select the first group "24 down to 45" then COPY
Then go to E2 right click Paste Special- Values check of Transpose
That should do it.

"heyredone" wrote:

I need help with transposing data from columns to rows. I have a worksheet
as follows (sample section):

A B C
1 NAME YEAR NO. OF WORKWEEKS
2 Person A 2003 24
3 Person A 2004 50
4 Person A 2005 49
5 Person A 2006 50
6 Person A 2007 52
7 Person A 2008 45
8 Person B 2008 2
9 Person C 2005 1
10 Person D 2003 15
11 Person D 2004 2
12 Person E 2004 17
13 Person E 2005 0
14 Person E 2006 17
15 Person E 2007 31

I need the No. of Workweek data for Person A to spread across 1 row
beginning at E2 (I have other data in column D), Person B's data across 1
row, and so on. Some employees have Workweek data for years 2003 through
2008 (such as Person A), some only have data for one year or some of the
years (such as Person B and Person D).

Can someone help me with an array that will work? Thanks so much.
--
heyredone