I have a set of record such as

category, group, location, area, division QTY

ITEM-A GROUP-A LOCA-A AREA-A DIVI A 1
ITEM-B GROUP-A LOCA-A AREA-B DIVI A 2
ITEM-C GROUP-A LOCA-B AREA-A DIVI A 4
ITEM-D GROUP-B LOCA-B AREA-A DIVI A 6
ITEM-E GROUP-B LOCA-E AREA-B DIVI A 9
ITEM-F GROUP-B LOCA-E AREA-B DIVI A 2


I WANT THE RECORD TO BE PRESENTED TO THE REPORT LIKE

DIVISION : DIVI A
LOCA-A-AREA-A LOCA-A-AREA-B LOCA-B-AREA-A LOCA-E-AREA-B
GROUP-A 1 2 4
ITEM-A 1
ITEM-B 2
ITEM-C 4
GROUP-B 6 11
ITEM-D 6
ITEM-E 9
ITEM-F 2


IS THAT POSSIBLE TO USE ARRAY CODING OR OTHER ELSE, I AM VERY POOR IN USING ARRAY, SO CODING GIVEN WILL BE REALLY APPRECIATED.

SORRY FOR MY ENGLISH. THANK YOU