Report Based on following sample of data

[aligahk06]

Dear All,

I want to generate a report. the data is as follows.

Col E ColF Col G
1" pipe 2
1.5" elbow 3
2" flange 1
1" pipe 1.5
4" tee 4

report in such a way .
Pipe 1" total
Elbow 1.5" total

and so on ....


Please assist ?

Rgds,
Aligahk06

[mdmackillop]

Try setting up a Pivot Table.