Follow

Keep Up to Date with the Most Important News

By pressing the Subscribe button, you confirm that you have read and are agreeing to our Privacy Policy and Terms of Use
Contact

Combining Two Unrelated Tables in Power Query and Repeat One Table for Every Row of the Other

I have two tables each comprised of 1 column. Table One [DATES] is a list of ordered months. Table Two [DEPARTMENTS] is a unique list of departments.

I want to combine the two tables, repeating the list of departments for every month in the [DATE] Table

Exmaple:
Table 1 [DATES]:

MEDevel.com: Open-source for Healthcare and Education

Collecting and validating open-source software for healthcare, education, enterprise, development, medical imaging, medical records, and digital pathology.

Visit Medevel

|MONTH     |
|1/31/2022 |
|2/28/2022 |
|3/31/2022 |

Table 2 [Departments]

|DEPARTMENT|
|A         |
|B         |
|C         |

How I want it to look:

|MONTH     |DEPARTMENT|
|1/31/2022 |A         |
|1/31/2022 |B         |
|1/31/2022 |C         |
|2/28/2022 |A         |
|2/28/2022 |B         |
|2/28/2022 |C         |
|3/31/2022 |A         |
|3/31/2022 |B         |
|3/31/2022 |C         |

I am not sure this is possible as joining requires at the least equivalent type columns to even join on.

Is this Doable?

>Solution :

In Table1, add column .. custom column .. with formula

=Table2

Then expand rows

Add a comment

Leave a Reply

Keep Up to Date with the Most Important News

By pressing the Subscribe button, you confirm that you have read and are agreeing to our Privacy Policy and Terms of Use

Discover more from Dev solutions

Subscribe now to keep reading and get access to the full archive.

Continue reading