Issue with copying Excel Pivot Tables to JMP

[#1]

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!

[#2]

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.