Formula to pull multiple matches on multiple criteria

[beginvbaanalyst]

Hello Everyone,

I don't know if this is possible but I'm hoping someone can help.

I have a set of data in the A column that is all linked to one piece of data. Within that data has multiple numbers.
For instance, I'd like a formula to pull every number next to tire onto each article. I would need it to transpose (I've seen textjoin which might be still useful?). Whats the best way of doing this? I would need 61474 to show up the same way the TIRE column is next to all the numbers, and it would continuously do this until it reaches the last number article # shown.

Please help.

 

[bobby_smith]

Can you provide a pic of what the desired output should look like?

 

[beginvbaanalyst]

This is a simple end result.

 

[bobby_smith]

I don't fully understand the output but it seems like what you are looking to achieve is called a Cartesian product.

Do a google search for Power Query Cartesian Product.
Here are two websites which maybe helpful.

Cartesian Product in Power Query: Multiply All Sets of All Pairs in Power BI - RADACAD

Sometimes, you need to create a multiplication of all sets of all pairs from two different data tables in Power BI. This action is different from Merge (Join) because there is no matching key columns and no way to relate the two tables together. However, you want to create a multiplication as a...

radacad.com

Cartesian Product Joins (for the Excel person)

While I was at the PASS BA conference in San Jose, CA last week, I got an email from a reader asking if Power Query could create a Cartesian Product join. Now I’m an Excel guy, and I’d never heard … Continue reading →

www.excelguru.ca

I hope these can get you closer to your answer.
Please let me know if this is what you were hoping to achieve.

 

[beginvbaanalyst]

Bump.

I realized what I pasted was the two exact same photos.
Here is an example, Here is my data.

In a new column without doing a drop down for 243169, I would need the end result to look like.

Would =textjoin work for this?
What formulas could I utilize?
Please help.