I have a dynamic spreadsheet where columns A-K dynamically update and change. However I have one column where static data is entered manually (Quantity) and I cannot figure out how to get the static data to stay in the same row as the dynamic data that it correlates to.

So basically I have column L which is the quantity of each item and I am trying to get the quantity of item (x) to stay in the same row as (x) where (x) is always changing rows when the dynamic data updates, however the static data (quantity) is not moving to the row of the item it previously corresponded to.

Any help with this would be greatly appreciated.