PDA

View Full Version : Organizing data in a spreadsheet



troelsi
12-21-2008, 09:18 AM
Dear experts.

Here's what you might think of as a simple question, however, it's something I have difficulties doing and I allways end up making a customized macro for it in VBA. But I suspect that excel has some sort of built in functions that would allow me to organize data faster and easyer.


Please consult the enclosed spreadsheet for a desription of my problem.

Thanks in advance

regard

troels

Bob Phillips
12-21-2008, 11:47 AM
Because you are transposing AND su mming, I think a macro is the only solution.

troelsi
12-22-2008, 12:16 AM
What do you mean by summing, I don't think I'm summing those data.

/troels

Benzadeus
12-22-2008, 09:09 AM
Does this help?

Paul_Hossler
12-26-2008, 05:42 PM
Pivot Tables

Paul