Ungroup/Expand rows into the number of rows specified by column
I need help to see how I can ungroup/expand rows into the number of rows specified by a column value
for example:
I am here:
| Start Date | End Date | Days | Number of Months | Number of Months +1 |
| 3/1/2026 | 5/31/2026 | 92 | 2 | 3 |
| 6/1/2025 | 6/30/2025 | 30 | 0 | 1 |
| 8/1/2025 | 9/30/2025 | 61 | 1 | 2 |I need help accomplishing the following 2 steps:
STEP 1:
Ungroup/Expand into the number of rows specified by “Number of Months +1” EX:
| Start Date | End Date | Days | Number of Months | Number of Months +1 | Month List |
| 3/1/2026 | 5/31/2026 | 92 | 2 | 3 | 1 |
| 3/1/2026 | 5/31/2026 | 92 | 2 | 3 | 2 |
| 3/1/2026 | 5/31/2026 | 92 | 2 | 3 | 3 |
| 6/1/2025 | 6/30/2025 | 30 | 0 | 1 | 1 |
| 8/1/2025 | 9/30/2025 | 61 | 1 | 2 | 1 |
| 8/1/2025 | 9/30/2025 | 61 | 1 | 2 | 2 |STEP 2:
Assign End of Month value for each row starting with end date and working backwards (EOM(service end date -“Number of Months +1” +" Month list"))
| Start Date | End Date | Days | Number of Months | Number of Months +1 | Month List | EOM |
| 3/1/2026 | 5/31/2026 | 92 | 2 | 3 | 1 | 3/31/2025 |
| 3/1/2026 | 5/31/2026 | 92 | 2 | 3 | 2 | 4/30/2026 |
| 3/1/2026 | 5/31/2026 | 92 | 2 | 3 | 3 | 5/31/2026 |
| 6/1/2025 | 6/30/2025 | 30 | 0 | 1 | 1 | 6/30/2025 |
| 8/1/2025 | 9/30/2025 | 61 | 1 | 2 | 1 | 8/31/2025 |
| 8/1/2025 | 9/30/2025 | 61 | 1 | 2 | 2 | 9/30/2025 |