First, wipe out any negative numbers if they shouldn’t be there, just set them to zero. Next, take each row and divide every number by the total of that row, this will force everything to add up to 100%. Finally, double-check by adding a quick sum column to make sure each row actually hits 100%. Easy fix! Btw, i think you should do it with Python or OriginPro. Let me know if you need any additional tips: https://wa.me/+923440907874