The reason for Z being gone from the third spreadsheet is because Z is an undesired category in the final report
The main objective of this process is to remove any quantity that has been entered in Z and instead allocated to the other categories.
There might be some flexibility on how the final spreadsheet is layed out as long as that objective is met.