This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
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: 
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 07:36 PM (552 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 (539 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.