Duplicating lines based on query cell value...

[blownbyyou]

So I was wondering if anyone has a suggestion on how I could do this....

I am trying to find a way to duplicate lines based on cell values, below is how I have the table currently..

[TABLE="width: 500"]
<tbody>[TR]
[TD]Item[/TD]
[TD]Fixed Lot Multiplier[/TD]
[TD]Total Qty Required[/TD]
[TD]Number of Work orders needed[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]2[/TD]
[TD]7[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]4[/TD]
[TD]13[/TD]
[TD]4[/TD]
[/TR]
</tbody>[/TABLE]

---

---

What I want it to do is take it from that above to show this


[TABLE="width: 500"]
<tbody>[TR]
[TD]Item[/TD]
[TD]Qty[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]4[/TD]
[/TR]
</tbody>[/TABLE]

As you can see I created as you can see I took the first table, item 1 and made 4 line items for qty 2 each. Then for item two I did the same...

Does this make sense? Does anyone have any suggestions?

 

[RoryA]

Sounds like this: https://www.mrexcel.com/forum/power-bi/995590-create-duplicate-rows-based-cell-value.html ?

 

[blownbyyou]

Awesome! Thank you soo much

 

[RoryA]

Glad to help.