Combine a single list of unique parts with a list of 35 components that belong to each part

[Jeffrey Green]

I have list of unique VINS.
I also have a list of 35 parts that belong to each VIN.

I need to combine these list so that i have A VIN, then 35 parts, then ANOTHER VIN with the same 35 parts, then a 3rd VIN, etc.

Seems like it should be easy . . . but stuck.

A macro would be nice . . . but maybe if someone could show me a non-macro way, that would be educational . .

thanks so much

 

[Jeffrey Green]

Solved, thanks