mkx

Ok here's the situation. I have one sheet with line by line unique items example:

Item Lala Lala2 Lala3
304 Spec Spec Spec
305 Spec Spec Spec
308 Spec Spec Spec
etc

then I have another sheet with repeat items example:

304
304
304
304
304
304
305
305
308
308
308
308

etc.

Is there a quick way of auto filling specs to the multiple item lines based on the information I have on the single item/line sheet? I reckon it will take me a couple hours to do this manually.