(Power Query) Bridge Query w/ Individual Records Linking to Different Table.Columns?

[SuperNerd]

I have a products Query with a list of all individual products. Each product's sales data are in separate Category Tables, with the individual products as columns, and the sales date as rows.

I want to create Pivot Tables for each individual product and their sales data.

I need a Bridge Query that will link each individual product to the corresponding category query and then that product's column.

What's the cleanest/easiest/most efficient way to do this in Power Query?

Thank you!

 

[SuperNerd]

Actually- ignore this post. I need to expand on it more- but the forum won't let me edit or delete it?