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: 
  • Learn how to build custom Python data connectors and further customize JMP’s Data Connector Framework with the Python Data Connector Demo, available now in the JMP Marketplace!
  • See how to create experiments to support product design and ID useful product features. Register for June 12 webinar, 2pm US Eastern Time.

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 (1873 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 (1860 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