In Power Query, if I have a table list this,
<tbody>
</tbody>
I want to repeat each Item by the number of times in the 'Times to repeat' column, with every other column just repeating the same values.
So given the above, I want an output like this,
<tbody>
</tbody>
Can I use List.Generate or Table.Repeat for this? Or what's the best way?
Item | Times to repeat | Other columns |
A | 3 | ABC |
B | 2 | DEF |
<tbody>
</tbody>
I want to repeat each Item by the number of times in the 'Times to repeat' column, with every other column just repeating the same values.
So given the above, I want an output like this,
Item | Times to repeat | Other columns |
A | 3 | ABC |
A | 3 | ABC |
A | 3 | ABC |
B | 2 | DEF |
B | 2 | DEF |
<tbody>
</tbody>
Can I use List.Generate or Table.Repeat for this? Or what's the best way?