Update:
We have been successful in using Yahoo Pipes to aggregate multiple RSS and Atom based feeds into one RSS feed. However, we found that you need to change the domain so that it is “Flash friendly” and allows cross site scripting. We changed “pipes.yahoo.com” to “pipes.yahooapis.com” and it works well.