excel spill error with row multiplication

Hi runner200 

There is some data that is be obstruction show the result, or the cell is merged. 

#SPILL! error introduce in Excel with Dynamic Arrays (Microsoft365 [formally Office365] – mac/windows and Excel Online) with new calculation engine to handle the array functionality.

this blog post might be help for you to more in detail about spill

How to correct a #SPILL! error - Office Support (microsoft.com)

https://excelexciting.com/what-is-the-spill-error-and-how-to-fix-it/

when you are sending the file to your colleague the information is not getting spill because he/she don't have new calculation engine to handle the array functionality. 

if you are still facing the issue kindly request you to please attach the sample file.

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official/Best Answer & like it to help the other members find it more