Greetings!

Suppose I have the following simple spreadsheet:

[Column A] ..................... [Column B] ..................... [Column C] .................................................. [Column D]

Something ..................... Something ..................... Yes / No ...................................................... Something

Something ..................... Something ..................... Yes / No / Maybe .......................................... Something

Something ..................... Something ..................... Yes / No / Maybe / Not Answered ..................... Something

What I would like to do is to create a macro that would parse Column C and split each answer to a new row so we end up with something like this:


[Column A] ..................... [Column B] ..................... [Column C] ............................ [Column D]

Something ..................... Something ..................... Yes ............................ Something
Something ..................... Something ..................... No ............................ Something

Something ..................... Something ..................... Yes ............................ Something
Something ..................... Something ..................... No ............................. Something
Something ..................... Something ..................... Maybe .............................. Something


Any ideas?

Thanks for your help in advance.