Summarize data in Excel

[LievenV]

Hi,

Anyone have asimple way to get from X to Y?

X:
Year Item Qty Sls
2004 A 1 25
2005 A 5 70
2004 B 2 23
2005 C 1 35
2005 D 6 7

Y:
2004 2005
Item Qty Sls Qty Sls
A 1 25 5 70
B 2 23
C 1 35
D 6 7

Thanks.

 

[dhulbert]

lievenV

Have a look at pivot tables.

Should do what you want.

I love deadlines. I like the whooshing sound they make as they fly by
Douglas Adams
(1952-2001)

 

[LievenV]

Thanks for your reply dhulbert.
The anoying thing with pivot tables is that the sum of qty and sum of sales are underneath oneanother instead of next to eachother. Or do you know how to change his?

 

[xlbo]

just drag the "DATA" cell to the right - you should see the faint grey outline move over to indicate where the data values will be

 

[LievenV]

Auch!
Thanks both!