I have a complex situation with my data and I would like to make a quick list of information for geographical plotting, here is my problem.

Data example:
--------------|--------------INCIDENT---------|----------LOCALE
DATE|-PERSON|-ONE--|-TWO--|THREE|FOUR-|-ONE--|-TWO--|THREE|FOUR
1/1--|-mr. a--|-theft--|-murder|------|------|1n2w--|-1n4w-|------|
1/1--|-mr. b--|-assault|-j-walk-|--dui-|------|2n1w--|-2n2w-|-2n2w|
1/2--|-mr. b--|-robbery|-------|------|------|1n1w--|-------|------|
1/3--|-mr. c--|-j-walk-|--------|------|------|2n3w-|-------|------|

I have more information that goes with each one but this illustrates my problem. each row represents an individuals work load for one instance on a given day so the information had to be recorded this way. but now I would like to extract the columns on the incidents with the locales so they can be plotted geographically, ie. :

theft----| 1n2w
murder--| 1n4w
assault--| 2n1w
j-walk --| 2n2w
dui------| 2n2w
robbery-| 1n1w
j-walk---| 2n3w

is there any tool to do this within excel. Macro, function, PivotTable, anything?