Given the following data set: Is being imported into the following cells: If PreserveDataOnMergedCells is equal to true , each value will be assigned to a cell or group of merged cells. The result for the above example would be: If PreserveDataOnMergedCells is equal to false , ImportData will treat all cells as though they are unmerged. Any additional values that are imported into merged areas will be lost. The result for the above example would be: |