I can turn the dates to months in TABLE 1 with =text (b2;"mmm.yy"), but how
do I consolidate the Item, months and volume, so I get TABLE 2:

TABLE 1

Item Date Volume
A 01.04.2010 10 000
A 01.04.2010 10 200
B 01.04.2010 9 800
A 15.04.2010 10 500
B 01.05.2010 9 750
B 01.05.2010 10 150
A 01.06.2010 10 200
B 01.07.2010 9 850


TABLE 2

Item Month Volume
A apr.10 30 700
B apr.10 9 800
B mai.10 19 900
A jun.10 10 200
B jul.10 9 850

--
Regards
Tommy