My excel sheet looks like this:

ID Product Product(2)
1 book pen
2 pen pen2
3 desk

I need to keep the same format but in a different sense more to look like this:

ID Product
1 book
1 pen
2 pen
2 pen2
3 desk

bascially in a sense i need to transpose it but i can't figure out how to do that. I have thousands of files and the person who gave me this excel sheet gave me it in a very funky format and now i need to change it around to import it into an access table for use online.

Any help would be appreciated. Thanks