i need help making a report from range of data

i have a range of data that looks like this:
product id, expense code, expense value

and i need to make a profits report that has this rows:
income
production expenses
marketing expenses
and so on.. when each expense has its on code on the data.

do i need to loop on every cell to get the data for
the report or there is an easier way?