Match multiple row in one worksheet to single row in another

I am a total newbie to asking questions on this forum so be kind if I've got it wrong. I have two csv files that have only two or three columns that I need to combine into one with thousands of rows...