How to expand a table on query editor using another unrelated table

[Nikochi]

The subject does not really express well what I am looking for so I will be more thorough here. I have a table that I created on Edit Query (Date table) and another categorical table (Grade in my case). 

NOTE: the two tables are unrelated, hence they have no column in common. 

What I need to do is, "merge/combine" them in such a way that each date is repeated for every category:

Date table

DateGradewhat I need is this Date+Grade

[Anonymous · Accepted solution]

@Nikochi -

In Power Query, you can do the following:

1. With your Date table selected, add a Custom Column. The formula will be = GradeTable.

2. Expand the new column and select the Grade column.

Cheers!

Nathan

[Nikochi]

@Anonymous  Thank you so much 🙂