Convert Report through Excel to Access

[JimS]

I know how to use an Excel spreadsheet in Access. I have a report created by
a third party that looks like this:

Package ID "A" Package "A" Description
Related Item A1 Related Item 1 Description
Related Item A2 Related Item 2 Description

Package ID "B" Pacakage "B" Description
Related Item B1 Related Item B1 Description

etc...

Package ID is supposed to be a subset of the related item ID, but is not
consistent, so I need to create a column called "Package ID" in each Related
Item row to compensate for that. I know how to remove the Package ID rows
once that's done, but anyone got an elegant way to get the package ID column
properly populated to a random number of its related items? I can do it, but
I can't think of any way to do it except "bludgeoning it to death", which is
more work than I want to do.

Ideas?
--
Jim