Mathematica Link for Excel handles empty cells differently depending on where the cells are located. | nontrailing empty | Empty | | trailing empty | trimmed from range |
Excel empty cell mapping. For empty cells to be trimmed, an entire trailing row or column within the range must contain nothing but empty cells. Notes • The trimming of trailing empty cells allows you to easily work with entire rows and columns of data. |
