Transpose formula

[pigsy101]

i have a data entry sheet which reads:



A B C D
E etc
Week 1 Week
2 etc
Actual Target Actual
Target etc
Pre-starts 5 5 2 4
Startups 10 6 12 15
Established 15 7 15 20

I need a summary sheet which transposes these figures to the following


A B C
D E F G
Prestarts
Startups Established
Actual Target Actual
Target Actual Target
Week 1 5 5 10
15 15 7
Week 2 2 4 12
15 15 20

i can't get the transpose formula to work when you have two columns
(actual and target) which need to be kept together.

any help will be gratefully received.

Paul

 

[Herbert Seidenberg]

This uses Pivot Table and Macro:
http://www.freefilehosting.net/download/3dlb9