https://community.jmp.com/t5/Discussions/Issue-with-copying-Excel-Pivot-Tables-to-JMP/m-p/412200#M66183 <P>The tabulate platform in JMP can do much of what pivot tables do in Excel.&nbsp; Could you bring the raw data into JMP instead?&nbsp; 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.</P> Tue, 24 Aug 2021 14:19:46 GMT ih 2021-08-24T14:19:46Z https://community.jmp.com/t5/Discussions/Issue-with-copying-Excel-Pivot-Tables-to-JMP/m-p/412139#M66173 <P><SPAN>Hi! I would like to know if there is a clever way to copy pivot tables with several columns of info into JMP.&nbsp; 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!</SPAN></P> Sat, 10 Jun 2023 23:36:06 GMT https://community.jmp.com/t5/Discussions/Issue-with-copying-Excel-Pivot-Tables-to-JMP/m-p/412139#M66173 Aziza 2023-06-10T23:36:06Z https://community.jmp.com/t5/Discussions/Issue-with-copying-Excel-Pivot-Tables-to-JMP/m-p/412200#M66183 <P>The tabulate platform in JMP can do much of what pivot tables do in Excel.&nbsp; Could you bring the raw data into JMP instead?&nbsp; 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.</P> Tue, 24 Aug 2021 14:19:46 GMT https://community.jmp.com/t5/Discussions/Issue-with-copying-Excel-Pivot-Tables-to-JMP/m-p/412200#M66183 ih 2021-08-24T14:19:46Z