If merged cells are in the data comments area, the merge will be kept vertically but not horizontally (along different columns)

Merged cells in data area will not be kept. The value will duplicate in each cell.

System variable is @XMD (default 1 to duplicate in data area)