Power Query Struggle - need help

[Anonymous]

So I have a distinct (no duplicate ) Column named "Date"
But on each date i want to put Category Column. This is the end result should be 

Date	Category
20-Dec	A
20-Dec	B
20-Dec	C
22-Dec	A
22-Dec	B
22-Dec	C
25-Dec	A
25-Dec	B
25-Dec	C

Hope this makes sense.
Thank you

[mahoneypat · Accepted solution]

In the query editor, add a custom column with the list of category values

= {"A", "B", "C"}

Then click the double arrow of the column and choose "Expand to New Rows".

Regards,

Pat