# Shifting Column Data by Row: Modify Row populates all the rows

**URL:** <https://connect.superhuman.com/t/shifting-column-data-by-row-modify-row-populates-all-the-rows/24095>\
**Category:** Ask the Community\
**Created:** [June 18, 2021, 2:05am UTC](https://connect.superhuman.com/t/shifting-column-data-by-row-modify-row-populates-all-the-rows/24095 "2021-06-18T02:05:05Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Admin\_Celium](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/admin_celium/32/18972_2.png) [@Admin\_Celium](https://connect.superhuman.com/u/Admin_Celium)\
**Post date:** [June 18, 2021, 2:05am UTC](https://connect.superhuman.com/t/shifting-column-data-by-row-modify-row-populates-all-the-rows/24095/1 "2021-06-18T02:05:05Z")

</div>

Using a Modify Row Button I am trying to move the values form one month column to the next, but instead it populates all the values from the next column in each row of the target month column.  
 ![Screen Shot 2021-06-17 at 6.59.23 PM](https://global.discourse-cdn.com/coda1/original/3X/7/3/73ec2c069bb98bd6c546cec6ed47b711022af698.png)

This is the Formula. How would I get it to populate from one row to the next specifically?  
`[Monthly Forecast Spend].Formulamap(currentValue.ModifyRows([Monthly Forecast Spend].[Current Month], [Monthly Forecast Spend].[Next Month]))`

Any help is appreciated! Thank You!

---

<div class="post-metadata">

**Author:** ![Scott\_Collier-Weir](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/scott_collier-weir/32/29677_2.png) [@Scott\_Collier-Weir](https://connect.superhuman.com/u/Scott_Collier-Weir)\
**Post date:** [June 18, 2021, 2:27am UTC](https://connect.superhuman.com/t/shifting-column-data-by-row-modify-row-populates-all-the-rows/24095/2 "2021-06-18T02:27:45Z")

</div>

Hey @Admin_Celium !

Try something like this

https://coda.io/embed/qwwZ_0SGFe/_suX5v?viewMode=embedplay

Here is the formula I used

 ![image](https://global.discourse-cdn.com/coda1/original/3X/6/f/6f7acef0738bf5b441a938715a8db1a937f33a4a.png)

Reach out if you need anymore help!

---

<div class="post-metadata">

**Author:** ![Renita](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/renita/32/16178_2.png) [@Renita](https://connect.superhuman.com/u/Renita)\
**Post date:** [June 18, 2021, 6:44am UTC](https://connect.superhuman.com/t/shifting-column-data-by-row-modify-row-populates-all-the-rows/24095/3 "2021-06-18T06:44:27Z")

</div>

Hey, Admin! Welcome to the Coda Community! It looks like you mixed up CurrentValue with a table reference, which makes the entire Next Month column get dumped into each row ([Monthly Forecast Spend].[Next Month]), when instead you just want that specific row’s value to be copied to the column for that row (CurrentValue.[Next Month]).

E.g.  
[Monthly Forecast Spend].Formulamap(CurrentValue.ModifyRows([Monthly Forecast Spend].[Current Month], **CurrentValue**.[Next Month]))

Hope this helps!

---

<div class="post-metadata">

**Author:** ![Admin\_Celium](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/admin_celium/32/18972_2.png) [@Admin\_Celium](https://connect.superhuman.com/u/Admin_Celium)\
**Post date:** [June 22, 2021, 3:28pm UTC](https://connect.superhuman.com/t/shifting-column-data-by-row-modify-row-populates-all-the-rows/24095/4 "2021-06-22T15:28:08Z")

</div>

Thanks for the help! That worked great!