I've got a table that contains a data set from which I create a UNIQUE list of companies, so for example:
I've also got a table of promotional data that I need to connect with each of these that contains multiple criteria, like so:
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?
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!
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!