move value to the relevant row

If you mean to actually physically move data from 1 cell to another, you cant do that with formulas, you will need VBA (code)

You can probably create a duplicate table and use formulas in it, referencing the 1st table, top show what you want.