Access Record Splitter

I have a client who has data like this in an access table: itemID itemName itemQuantity 1 Corvette 1 2 Mustang 2 3 Camaro 5 He wants to append the data to another table so it looks like this: itemID itemName itemQuantity 1 Corvette 1 2 Mustang 1 2 Mustang 1 3 Camaro 1 3 Camaro 1 3 Camaro 1 3 Camaro 1 3 Camaro 1 He needs it in this format so that he can export it to excel (for some unknown reason). Is there an easy way to do this?