How do I add rows below certain cells in Power Query

[vcan]

Hello, 

I am very new to Power Query and could use some help!

We have products such as Variety Packs that contain an assortment of existing products.  In order to get a full count of each product, we need to account for the units in the Variety Packs as well.  However, our data does not break up the Variety Pack by whats included inside, and just says "Variety Pack".

I was wondering if it were possible in Power Query to conditionally add a certain amount of rows under "Variety Pack" every time is occurs.  

Desired Data: (Currently just the Variety Pack line)

This would have to be done separately for different variety packs as well.

I can elaborate more if needed! Any help is appreciated!

[jbwtp]

Hi @vcan,

This is  possible. You can use something like List.Accumulate(Table.ToRecords(...), ...) and analise it or few otherstrategies, but would you be able to explain why would you need it? The data tables works in a quite different way compared to e.g. Excel. Generally, there is no guarantee that the lines will be processed in a certain sequence in DAX or visual after the data is passed from the query. What is your plan for controlling after which Variety Pack any given Product A is following?

Thanks,

John