Hi:

You will need to do the following
-Make certain the report is sorted by Item code (likely the case already)
-Create 6 Calculated Columns (one for each Location) using IF() formula
-Make certain that those 6 columns have totals at the bottom
-Use the "Summarize" button so that each item rolls up to just one row

If you have trouble with the IF() clause, let us know.