Users are constantly handling messy spreadsheets, many of them containing combined cells as headers.
JMP Excel add-in is great for ad-hoc analysis, arguably the best way to introduce the value of JMP to new users.
However, it cannot handle combined cells as it happens with the Excel wizard.
Minimum example (also attached):
![FN_4-1677768853910.png FN_4-1677768853910.png](https://community.jmp.com/t5/image/serverpage/image-id/50642i78078E0195CA3663/image-size/medium?v=v2&px=400)
Results using Excel add-in:
![FN_5-1677768853916.png FN_5-1677768853916.png](https://community.jmp.com/t5/image/serverpage/image-id/50641i1DA41687D86D0D0D/image-size/medium?v=v2&px=400)
However, when using the Excel Wizard to import the file, it works as expected:
![FN_6-1677768853917.png FN_6-1677768853917.png](https://community.jmp.com/t5/image/serverpage/image-id/50643i793F7513FE9CFD5A/image-size/medium?v=v2&px=400)
![FN_7-1677768853918.png FN_7-1677768853918.png](https://community.jmp.com/t5/image/serverpage/image-id/50644i382DD564C9DA8B1E/image-size/medium?v=v2&px=400)
minimum_example_combined_cells_excel.jmp