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: Than...
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
mahoneypat
Microsoft Employee
Microsoft EmployeeJust 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