Create the specified number of lines from one line.

[Anonymous]

Hello everyone.
I have a table. In one column - the number of the event, in the second - the quantity. I really need to decompose such lines into several. If there are 4 events, then 4 lines are needed, if 2 - then two. How can this be done optimally?

[Anonymous · Accepted solution]

In PQ add new column: 

   Table.AddColumn(prev_step, new_column_name, each List.Numbers(1,[COUNT])),

 where [COUNT] is column with events count.

Then expand lists in new column.