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: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
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 (918 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 (905 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.