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.
Bookmarks