Transpose formula

P

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top