Organizing data in a spreadsheet

[troelsi]

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]

Because you are transposing AND su mming, I think a macro is the only solution.

[troelsi]

What do you mean by summing, I don't think I'm summing those data.

/troels

[Benzadeus]

Does this help?

[Paul_Hossler]

Pivot Tables

Paul