Thanks Skip, I think a pivot table is the way to go to, but to make it work, I had to reorder the spreadsheet manually to get the format I wanted in terms of output. And it did do pretty much what I wanted to do, but the problem is the actual csv that the application spits out doesn't look...