Re-opening is not a problem. Please manually place what you expect to see in rows 4:6 into three of the rows further down the sheet (i.e. rows 7:9) so that we will have something upon which to base the results of our formulas/code.
In looking at this again, I am thinking that I will employ some helper columns, perhaps columns XEY:XFD. Will that be acceptable?
Let us know if you have any questions.