I have two sheets that have basically the same layout (a couple of columns are rearranged). What I'm wanting to do is take the data from one sheet and combine it with another. The trick that's keeping me from just FILTERing it and being done with it is that the "Qty" column needs to do some math.

The first sheet lists all items. The second lists "adjustments". So I might reduce one item by 50% or 100%. The goal is that the math will appear on this third/merged sheet and if an item is reduced by 100%, it will be completely removed.

```
projectTasks!A,B,C,D,E,G
projectTasksAdj!A,B,C,D,F,E
Adding projectTasks!E to projectTasksAdj!F

```

Main data sheet: projectTasks
Adjustments: projectTasksAdj
Merged sheet: reportsTasks

The columns are out of order in projectTasksAdj just for searching purposes.

[Here's my sheet](https://docs.google.com/spreadsheets/d/1-FdpxsNcrqXXWroYzeAQZz5TuyEX6xKnTif0rrrJl60/edit#gid=244517454&range=A3)

Thank you very much for any guidance!