I've found some good starting points to my problem, but I've yet to find a complete solution for what I'm trying to do. This solution seems to come close (I'm not sure if I can post links):
As shown in the attached example, I need to take it one step further. I have a schedule that is basically a spreadsheet of dates, with project names as my left column and schedule items as my header. I do some simple cell formatting and save the file as a CSV (all done in VBA) in order to import it into a MySQL database. Every schedule item column is followed by an 'actualized' column, to show if the schedule item occurred as specified. It's not common, but in some cases we'll need to schedule a second 'Meeting 2' or 'Submit Draft' which means one cell now has two dates (return delimited, ASCI 0010). For each date and corresponding 'A' (actualized status), I need to parse cells with multiple values into single rows. If it's any help, the person that updates our schedule is very consistent in accounting for schedule items with 2 or 3 dates, so any actualized column that follows a cell with multiple dates will have a matching number of 'A's and/or returns.
I'm not even sure if there is a slam-bang solution to this problem, since the macro would have to parse cells consistently across multiple columns, and not just parse all cells with multiple delimited values. I hope this makes some sense, and I would GREATLY appreciate any and all help.
Thanks a ton! Not to butter you up or anything . . . but you are some kind of genius if you can figure this out.