Is there a way to transpose many columns to rows? In my screen example I've got the top section but I want it the way it looks in the bottom section.
Thanks,
Kirsten
Thanks,
Kirsten
example for MrExcel.xls | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
1 | Howitlooksnow: | |||||||
2 | Charge | Staff/ObjCD | 2006P1 | 2006P2 | 2006P3 | 2006P4 | ||
3 | P15299.002 | Doe,John(ForecastHours) | 155 | 155 | 0 | 150 | ||
4 | P15299.002 | Doe,John(ActualHours) | 146 | 108 | 131 | 135 | ||
5 | P15299.002 | Smith,Scott.(ForecastHours) | 160 | 160 | 0 | 150 | ||
6 | P15299.002 | Smith,Scott.(ActualHours) | 134 | 152 | 134 | 119 | ||
7 | P15299.003 | Johnson,ValerieC.(ForecastHours) | 160 | 160 | 0 | 150 | ||
8 | P15299.003 | Johnson,ValerieC.(ActualHours) | 134 | 152 | 134 | 119 | ||
9 | ||||||||
10 | ||||||||
11 | HowIwantittolook: | |||||||
12 | Period | Name | Charge | ForecastedHours | ActualHours | |||
13 | 2006P1 | Doe,John | P15299.002 | 155 | 146 | |||
14 | 2006P2 | Doe,John | P15299.002 | 155 | 108 | |||
15 | 2006P3 | Doe,John | P15299.002 | 0 | 131 | |||
16 | 2006P4 | Doe,John | P15299.002 | 150 | 135 | |||
17 | 2006P1 | Smith,Scott | P15299.002 | 160 | 134 | |||
18 | 2006P2 | Smith,Scott | P15299.002 | 160 | 152 | |||
19 | 2006P3 | Smith,Scott | P15299.002 | 0 | 134 | |||
20 | 2006P4 | Smith,Scott | P15299.002 | 150 | 119 | |||
21 | 2006P1 | Johnson,ValerieC. | P15299.003 | 160 | 134 | |||
22 | 2006P2 | Johnson,ValerieC. | P15299.003 | 160 | 152 | |||
23 | 2006P3 | Johnson,ValerieC. | P15299.003 | 0 | 134 | |||
24 | 2006P4 | Johnson,ValerieC. | P15299.003 | 150 | 119 | |||
forecast-1 |