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

#### Tarver

##### Board Regular
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!

### Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

#### Dossfm0q

##### Banned User
Book1
ABCDEF
1Amazon
2Avis
4Burger Town
5
6
8Washington Post2/1/20212/5/2021\$50,000
9Miami Herald2/3/20212/4/2021\$40,000
10
11
12
13
15AvisWashington Post2/1/20212/5/2021\$ 50,000
16AvisMiami Herald2/3/20212/4/2021\$ 40,000
19Burger TownWashington Post2/1/20212/5/2021\$ 50,000
20Burger TownMiami Herald2/3/20212/4/2021\$ 40,000
21
22
Sheet1
Cell Formulas
RangeFormula
A15:A22A15=IFERROR(INDEX(\$A\$2:\$A\$4,CEILING(ROWS(\$A\$15:A15),ROWS(\$A\$8:\$A\$9))/ROWS(\$A\$8:\$A\$9)),"")
B15:E22B15=IF(\$A15<>"",INDEX(A\$8:A\$9,MOD(ROWS(B\$15:B15)-1,ROWS(A\$8:A\$9))+1),"")

#### Tarver

##### Board Regular
This works for me! Thanks very much!

Replies
4
Views
63
Replies
2
Views
66
Replies
26
Views
318
Replies
6
Views
216
Replies
19
Views
389

1,129,515
Messages
5,636,793
Members
416,941
Latest member
shazzaxyz

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back