User Community
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • New to JMP? Join us Sept. 23-24 for the Early User Edition of Discovery Summit, tailor-made for new users. Register now for free!
  • Use World Cup data to build models, explore spatial relationships, and create informative visualizations in JMP. Register. July 17, 2 pm US Eastern Time.
  • Your voice matters! Tell us how you prefer to receive JMP updates, so we can tailor our communication to your needs. Take short survey.

JMP Wish List

We want to hear your ideas for improving JMP. Share them here.
Choose Language Hide Translation Bar
0 Kudos

Loading combined cells when using Excel add-in

Status: New Submitted by on ‎03-02-2023 09:58 AM
Comment

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

 

Results using Excel add-in:

FN_5-1677768853916.png

 

However, when using the Excel Wizard to import the file, it works as expected:

FN_6-1677768853917.png

 

FN_7-1677768853918.png

 

 

minimum_example_combined_cells_excel.jmp
minimum_example_combined_cells_excel.xlsx