Hi,
i have dates in my column "H" and Column "I" represents the number of months missing, so how can i get the output like
Pricedate+2= Aug, Sep and soo on.
@Kapil_Lambhate I used the Generate Rows tool to create a record until RowCount <= Missing Month Price. Then I used the Formula tool to calculate the missing months and format that into abbreviated month names. Lastly, I used a Summarize tool to group by PRICEDATE and Missing Month Price then concatenate the month names with a comma delimiter.