Transpose many columns to rows

[KirstenNJ]

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

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

 

[Domenic]

Assumptions:

1) Each staff member contains two rows worth of data, Forecast and Actual.

2) For each staff member, the charge number for Forecast is the same as the charge number for Actual.

Formulas:

A13, copied down:

=IF(ROWS($A$13:A13)<=ROWS($A$3:$A$8)/2*COLUMNS($C$2:$F$2),INDEX($C$2:$F$2,MOD(ROW(A13)-ROW($A$13),COLUMNS($C$2:$F$2))+1),"")

B13, copied down:

=TRIM(PROPER(SUBSTITUTE(UPPER(INDEX($B$3:$B$8,(INT((ROW()-ROW($D$13))/COLUMNS($C$2:$F$2))+1)*2-2+1)),"(FORECAST HOURS)","")))

C13, copied down:

=INDEX($A$3:$A$8,(INT((ROW()-ROW($D$13))/COLUMNS($C$2:$F$2))+1)*2-2+1)

D13, copied down:

=INDEX($A$3:$F$8,(INT((ROW()-ROW($D$13))/COLUMNS($C$2:$F$2))+1)*2-2+1,MATCH($A13,$A$2:$F$2,0))

E13, copied down:

=INDEX($A$3:$F$8,(INT((ROW()-ROW($D$13))/COLUMNS($C$2:$F$2))+1)*2-2+2,MATCH($A13,$A$2:$F$2,0))

Hope this helps!