How can I repeat a list of items attached to a unique list?

[Tarver]

I've got a table that contains a data set from which I create a UNIQUE list of companies, so for example:

Amazon

Avis

Best Buy

Burger Town

I've also got a table of promotional data that I need to connect with each of these that contains multiple criteria, like so:

Advertiser	Start Date	End Date	Cost
Washington Post	02/01/2021	02/05/2021	$50,000
Miami Herald	02/03/2021	02/04/2021	$40,000

There are hundreds of entries for each table.

Is there a formulaic way to repeat the promotional data for each of the companies? to get an output like the following?

Company	Advertiser	Start Date	End Date	Cost
Amazon	Washington Post	02/01/2021	02/05/2021	$50,000
Amazon	Miami Herald	02/03/2021	02/04/2021	$40,000
Avis	Washington Post	02/01/2021	02/05/2021	$50,000
Avis	Miami Herald	02/01/2021	02/04/2021	$40,000
Best Buy	Washington Post	etc.	etc.

I keep trying to combine the two with the UNIQUE and SORT function, but I'm not having luck there. I even thought Power Query might be the answer, but I can't seem to get it to combine the two tables, and I'd really like a formula solution that doesn't require updating the query each time. Can this be done?

Thanks!

 

[Dossfm0q]

Book1
	A	B	C	D	E	F
1	Amazon
2	Avis
3	Best Buy
4	Burger Town
5
6
7	Advertiser	Start Date	End Date	Cost
8	Washington Post	2/1/2021	2/5/2021	$50,000
9	Miami Herald	2/3/2021	2/4/2021	$40,000
10
11
12
13
14	Company	Advertiser	Start Date	End Date	Cost
15	Avis	Washington Post	2/1/2021	2/5/2021	$ 50,000
16	Avis	Miami Herald	2/3/2021	2/4/2021	$ 40,000
17	Best Buy	Washington Post	2/1/2021	2/5/2021	$ 50,000
18	Best Buy	Miami Herald	2/3/2021	2/4/2021	$ 40,000
19	Burger Town	Washington Post	2/1/2021	2/5/2021	$ 50,000
20	Burger Town	Miami Herald	2/3/2021	2/4/2021	$ 40,000
21
22
Sheet1

Cell Formulas
Range	Formula
A15:A22	A15	=IFERROR(INDEX($A$2:$A$4,CEILING(ROWS($A$15:A15),ROWS($A$8:$A$9))/ROWS($A$8:$A$9)),"")
B15:E22	B15	=IF($A15<>"",INDEX(A$8:A$9,MOD(ROWS(B$15:B15)-1,ROWS(A$8:A$9))+1),"")

 

[Tarver]

This works for me! Thanks very much!