Generate Row by "End month" for each groups

Question

I know there are nice Generate Row articles but it does not work even if doing it yourself.

(It's my ability problem......)

I want to generate future rows by "Product end date" for Each Product Groups(Model column).

I guess I need to use "Generate rows" but I'm not sure how to do it for each product....

I also attached sample file.

It is very greatefule is someone help me.

Generate raw (Autofill) sample.xlsx

DataBlender · Accepted Answer

Hi @Becky,

Please find workflow attached. I first summarized your data before performing the generate rows function, then unioned the new rows back on to the original data.

jdunkerley79 · Accepted Answer

I would do the following:

* Use a summarise tool to get the range of dates needed for each Model, Region
* Generate rows to create the entire data set needed
* Join back to the original data set
* Use a union to put in the 'future' rows.

Sample attached.