Recording a Macro in Excel is easy, such a macro is often quite easy to modify to your needs - assuming you have some "BASIC" knowledge (note; Basic knowledge of "BASIC" language).
As you didn't tell which version of Excel you have;
- Find "Record new Macro"
- close to that you should have "Use relative references" - make that option be "active"
- Place the cursor on the top of an item in "Column C", where the first word differs from the NEXT row.
- Click on/Select "Record new macro"
- Press F2, then END, Type ONE SPACE, press ENTER (This "Edits" the cell contents and makes it appear in the Macro)
- Find and select "Insert, Cells, Entire row" in the menus (Or use the keyboard shortcut if you know it).
- Hit cursor down ONCE.
- Select "Stop recording"
Press ALT+F8 - find the macro, click on the name,
then find the [Options]-button, click on it and set a keyboard shortcut for the macro. Hmm... I believe there is an "Edit" button, not sure though - Close the dialog.
Now, what you need to do is edit this recorded macro... ;-) with your BASIC-knowledge.
Press ALT+F11 to get to the macro editor.
If you do not know how to edit it, copy out the macro's code from the editor and paste it in your question above and someone (me maybe) may edit it for you.