Forum Discussion
CTozzi
Resolver I
Resolver IHow to generate 12 rows for each existing row with Power Query
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!
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
1 Reply
- mahoneypat
Microsoft Employee
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