Please see the following example: Column A, B, and C. What I want to use VBA to do is: in the exel spreadsheet, if there are duplicates in Column C as in the example, I want to copy and paste A and B column values to the next row.

a b c
abc edf 123456
123456
So it will become:
a b c
abc edf 123456
abc edf 123456


There are about 50 rows, and this kind of situation appears unregularly and randomly, but only these three column. PLEASE HELP! THANK YOU SO MUCH!