I have a worksheet that has 3360 rows of data where the first 3 columns define Part Number, Description and Model type. Columns D through V define the Model Series. I have a need to define each model series on a separate row, however, I need to repeat the first three cells of every row for every Model Series. Some Part Numbers have no Model Series available, and some have 19.

I believe the best way to handle this is through Macro, I'm just not sure where to start. Any help would be greatly appreciated. I've attached a sample workbook with Input Data, which is what I currently have and Output Data which is what I want it to look like (minus the formatting) Eligibilty Sample.xlsx

Thanks in advance for your help.