Yes - I see now how record 3 contains everything above. I still think that it is worth running a "clean up" type macro first and maybe putting the Result ID and Comments columns into a template which contains the macro from before that can then be run to get the desired Results column.
The issues are whether there are other columns of data that you need in the final results, whether they vary, and finally what you want to do with the data at the end, etc.
