Split data into rows based on two column variables

[Juzer]

Dear All

I want to split my data into rows based on condition in columns. Data has two columns start date and end date

usually start date will be 1st of the month and accordingly last date will be end of the month date. Based on diff between two dates that many rows need to be created with other data repeating as it is but start date and end date will change month on month depending on number of months between start date and end date. I am giving an example here 

Input

Name Start Date End Date No of Months No of Rows

ABC 01/04/2023 30/06/2023 3 3

RST 01/02/2023 31/03/2023 2 2

XYZ 01/01/2023 31/01/2023 1 1

Output

Name Start Date End Date

ABC 01/04/2023 30/04/2023

ABC 01/05/2023 31/05/2023

ABC 01/06/2023 30/06/2023

RST 01/02/2023 28/02/2023

RST 01/03/2023 31/03/2023

XYZ 01/01/2023 31/01/202

[Peachyco]

We have to use Generate Rows tool to create the months between [Start Date] and [End Date], like so:

 

[Juzer · Accepted solution]

thanks pecheko!!!!

it's working fine