Matching comma delimited items by position in set

Question

I have two separate queries that I'm trying to combine in Power Query by a unique project ID.

The first query has two columns, one with a unique ID, and the other with a comma-delimited list of document names:

e.g.

Project# | Document Name

1-123 | Summary, Invoice
1-456 | Summary, Invoice, Contract

The second query has two columns, one with a unique ID corresponding to the first table, and the other with a comma-delimited list of document IDs:

e.g.

Project# | Document ID

1-123 | 4e40117f, 44d9bb10
1-456 | 990dfcf9, 87e34673, 9296580c

I've verified that the document name and its document ID are in the same position within their delimited lists, but I need help in combining them into one query which separates them into individual line items:

e.g.

Project# | Document Name | Document ID

1-123 | Summary | 4e40117f
1-123 | Invoice | 44d9bb10
1-456 | Summary | 990dfcf9
1-456 | Invoice | 87e34673
1-456 | Contract | 9296580c

Any ideas would be greatly appreciated!