I have some data which follows this pattern

1-p 1 3
3-e 3 3
4-d 4 2
6-f 4

I need a macro that will recognize that numbers 2 and 5 is missing, insert
blank rows in their positions, as well as the appropriate value from a list
(say, "2-g" and "5-c"), and then create a list on the same spreadhseet of
each value which is inserted. furthermore, it needs to recognize whether the
values are absent for both columns or only for one. If that isn't complicated
enough, there are some rows which will always be missing ("2-g" in this
example), and while I need them to be inserted, I don't want them to be
listed as missing. After running the macro, it should look like this

1-p 1 3 missing clones 1: 5, 6
2-g 2 7 missing clones 2: 5
3-e 3 3
4-d 4 2
5-c
6-f 4

Any help would be greatly appreciated.
- matt