All - I have a form that tracks values and modifications to aircraft. On each form, the user has the ability to calculate 6 aircraft at a time. I use a grid to store the modification; grid1, grid2....

In each grid there could be different or the same data. I export this data to an excel sheet. My problem is, I don't want to repeat the data in a description column. How do I store the string and decimal and then search to see if the string exists and if it does, just add the decimal?

Data Example
Aircraft1
EGWPS Yes $80,000
Thrust Reverser Yes 125,000
Engine Program Yes 300,000

Aircraft2
TCAS Yes 250,000
EGWPS Yes 45,0000
Thrust Reverser Yes 25,000
EVS Yes 450,000


Current Report Format
Aircraft1 Aircraft2
Value 1.1M 7.5M
Modifications:
EGWPS 80,000
Thrust Reverser 125,000
Engine Program 300,000
TCAS 250,000
EGWPS 45,000
Thrust Reverser 25,000
EVS 450,000

What I want
Aircraft1 Aircraft2
Value 1.1M 7.5M
Modifications:
EGWPS 80,000 45,000
Thrust Reverser 125,000 25,000
Engine Program 300,000 0
TCAS 0 250,000
EVS 0 450,000