Announcements
If I have a table that has three columns as below
Is it possible to add 12 rows for each month in a year for each of the existing rows so that you get the below:
So you want the existing entry to be month 1 and then add 11 more rows for each one?
yes exactly
@nekinekic
The following formula will produce the results you are looking for:
Ungroup( ForAll(yourTableDataSource As _item, {item: ForAll(Sequence(12), Patch(_item, {Month:Value}))} ), "item" )
I hope this is helpful for you.
This worked. Thank you so much!
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 542 Most Valuable Professional
Haque 206
Kalathiya 201 Super User 2026 Season 1