I am trying to consolidate how much equipment is issued to a location over a year, this equipment is recorded in a spreadsheet each time it is issued by date, the spreadsheet contains columns for each unit over that time. I would like to consolidate this into a second tab that consolidates all of the columns by location
<tbody>
</tbody>
The data from the table above needs to be collated into the table below:
<tbody>
</tbody>
Equipment Issued | |||||
Date | 1/01/2014 | 1/01/2014 | 3/01/2014 | 8/01/2014 | |
Location | Location X | Location Y | Location X | Location Z | |
Equipment Issued | |||||
CHAINSAWS & ACCESSORIES | 2 | 1 | 2 | ||
Chainsaw | 2 | ||||
Chainsaw | 2 | ||||
Chainsaw | 2 | ||||
Chainsaw | 2 | ||||
Chainsaw | 1 | ||||
Polesaw | 9 | ||||
Polesaw Harness | |||||
Chain sharpener | |||||
Vacuum cleaner | |||||
Quick cut | |||||
Bar oil | |||||
Chainsaw Bar | |||||
Chainsaw Bar | |||||
Chainsaw Bar | |||||
Chainsaw Bar |
<tbody>
</tbody>
The data from the table above needs to be collated into the table below:
Location X | Location Y | Location Z | |
CHAINSAWS & ACCESSORIES | |||
Chainsaw | |||
Chainsaw | |||
Chainsaw | |||
Chainsaw | |||
Multi purpose rescue tool | |||
Polesaw | |||
Polesaw Harness | |||
Chain sharpener | |||
Vacuum cleaner | |||
Quick cut | |||
Bar oil | |||
Chainsaw Bar | |||
Chainsaw Bar | |||
Chainsaw Bar | |||
Chainsaw Bar |
<tbody>
</tbody>