Since what you want to do is un-normalize the tables, just do the reverse of what you'd normally do to normalize them :-).

updateSheesh, it's a joke about first-normal form. There was a smiley. I'm sorry if this appeared to be belittling the OP's question, that wasn't my intention.