In JMP 16.2, the Excel add-in doesn't merge combined cells as it happens with the Excel wizard.
Let's create a table with combined cells (a common practice in Excel). [see attached]
Row | A | B | C | X | Y | Z |
1 | 0.776217 | 0.983486 | 0.257156 | 0 | 0 | 0 |
2 | 0.976018 | 0.996587 | 0.680165 | 1 | 0 | 1 |
3 | 0.952502 | 0.864537 | 0.167309 | 0 | 1 | 0 |
4 | 0.199349 | 0.347625 | 0.228531 | 1 | -1 | -1 |
5 | 0.187644 | 0.888905 | 0.947407 | 0 | 0 | -1 |
6 | 0.420203 | 0.496739 | 0.786041 | -1 | 0 | 1 |
Using Excel-addin (preferences changed).
![FN_0-1677671248815.png FN_0-1677671248815.png](https://community.jmp.com/t5/image/serverpage/image-id/50561i5DFEC0D9D14232AD/image-size/medium?v=v2&px=400)
You get this:
![FN_1-1677671281852.png FN_1-1677671281852.png](https://community.jmp.com/t5/image/serverpage/image-id/50562i1EFBB6F94975D969/image-size/medium?v=v2&px=400)
However, when using the Excel Wizard to import the file, it works as expected:
![FN_2-1677671407744.png FN_2-1677671407744.png](https://community.jmp.com/t5/image/serverpage/image-id/50563i5A12552103F83A34/image-size/medium?v=v2&px=400)
![FN_3-1677671507459.png FN_3-1677671507459.png](https://community.jmp.com/t5/image/serverpage/image-id/50564i0B44578E21F13FDE/image-size/medium?v=v2&px=400)
Is this something happening in JMP 17 as well?