I'm not sure if Concetating is the exact way to go about this but what
I'm trying to do is take:

Drawing Amount | Drawing Number
--------------------------------------------------
4 506888
6 506889
2 506888
3 506889


And make it look like:


Drawing Amount | Drawing Number
--------------------------------------------------
6 506888
9 506889


Through a button-push on VBA.
Anyone have any ideas on how to accomplish this?