Combining two unrelated Tables

[adcook]

 All,

I am trying to create a new table from two completely differant tables. I am not sure on the best way to join them or if it is possible. The easiest way to explain it is through an example. Please see below. I want to make it smart though, so that if a sales rep is added to Table 1 than the new table will show that new sales rep with the three possible attributes. I hope this makes sense. Thanks!

Table 1

Column 1

Sales Rep 1

Sales Rep 2

Table 2

Column 1

Attribute 1

Attribute 2

Attribute 3

New Table Output

Column 1          Column 2

Sales Rep 1        Attribute 1

Sales Rep 1        Attribute 2

Sales Rep 1        Attribute 3

Sales Rep 2        Attribute 1

Sales Rep 2        Attribute 2

Sales Rep 2        Attribute 3

[aka · Accepted solution]

@adcook basically you want to create a cross join betwee two tables

please look at this link, it might be helpfull

http://exceleratorbi.com.au/cross-join-with-power-query/

[adcook]

Thank you so much, this did the trick!