Manage multivalued attributes

Hi there,

I've got a task to design a dimensional data model and group data accordingly in excel. While doing that, I discovered that one of the dimensions consisted of multivalued attributes (i.e. one-to-many relationship), which had to be converted into multiple one-to-one relationships in excel. Attached is the file with sample data, where Sheet 1 is the current situation, and Sheet 2 is what I would like to achieve. Please help me out. Thanks a lot.

(NOTE: The actual workbook consists of almost a million rows, so I would really appreciate it if the codes do not have many repetitive processes that need to be written)