How to generate 12 rows for each existing row with Power Query

[CTozzi]

Hi everyone,

I have a table with monthly target sales by product and Seller as below:

And I would like to add a NEW column and 12 lines for each existing lines as below:

Thank you very much!

[mahoneypat · Accepted solution]

Just add a custom column in the query editor with this formula   = {1..12}

That will add a list on each row.  You then just need to click on the expand button on the top of that column and choose "Expand to New Rows".

Pat