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.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
Aziza
Aziza
Level IV

Issue with copying Excel Pivot Tables to JMP

Created: Aug 24, 2021 07:59 AM  |  Last Modified: Jun 10, 2023 4:36 PM (2013 views)

Hi! I would like to know if there is a clever way to copy pivot tables with several columns of info into JMP.  Excel groups them into categories, but when you copy the Pivot table into JMP, it just has blank values. I have not found a good trick for this aside from actually complex formula rows and then copy paste. If anyone has a trick for this, it would be super helpful to share!!! Thanks!

Greetings
0 Kudos
1 REPLY 1
ih
Super User (Alumni) ih
Super User (Alumni)

Re: Issue with copying Excel Pivot Tables to JMP

Aug 24, 2021 10:19 AM (2000 views)  |  Posted in reply to message from Aziza 08-24-2021

The tabulate platform in JMP can do much of what pivot tables do in Excel.  Could you bring the raw data into JMP instead?  That would enable you to both get your summarized values and also to analyze your data in ways that pivot tables and excel does not provide.

Recommended Articles