Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Tranpose data from columns to rows
Hi,
Based on your post if you enter the following formula in E2 and copy it down and then over =SUMPRODUCT(--($A$2:$A$15=$D2),--($B$2:$B$15=E$1),$C$2:$C$15) Where the you list in in columns A:C, you have a unique list of Names in D2:D10 and the years are in E1:J1. However, I have to second the suggestion of using a pivot table, with names in the row area, years in the column area and weeks in the data area. If this helps, please click the Yes button, Cheers, Shane Devenshire "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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002: How to tranpose data to designated cells ? | Excel Discussion (Misc queries) | |||
Arrange data spanning 8 columns and 3 rows to 24 columns and 1 row | Excel Discussion (Misc queries) | |||
Excel 2002: Any formula to tranpose columns into rows ? | Excel Discussion (Misc queries) | |||
Tranpose? | Excel Discussion (Misc queries) | |||
Open txt file with more than 256 columns (how to tranpose in rows)? | Excel Discussion (Misc queries) |