add missing values for major and minor axis in the last row