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: 
  • New to JMP? Join us Sept. 23-24 for the Early User Edition of Discovery Summit, tailor-made for new users. Register now for free!
  • Your voice matters! Tell us how you prefer to receive JMP updates, so we can tailor our communication to your needs. Take short survey.
  • See how to access JMP Marketplace - and - find, create & share add-ins to extend your JMP. Watch video.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
saitcopuroglu
saitcopuroglu
Level IV

Wouldn't it be nice to export tabulate to excel with header rows as hierarchies

Created: Jul 30, 2015 08:48 AM  |  Last Modified: Oct 18, 2016 5:05 PM (11096 views)

We are able to import multiple column header rows as hieararchies when importing excel to jmp. Wouldn't it be nice to be able to to it opposite way directly from tabulate to excel with merged cells..etc...?

9336_2015-07-30_15-42-40.png

9337_2015-07-30_15-44-18.png

0 Kudos
1 ACCEPTED SOLUTION

Accepted Solutions
KarenC
Super User (Alumni) KarenC
Super User (Alumni)
Solution

Re: Wouldn't it be nice to export tabulate to excel with header rows as hierarchies

Jul 30, 2015 03:24 PM (13807 views)  |  Posted in reply to message from saitcopuroglu 07-30-2015

Hmm, I am always trying to get data out of excel and into JMP, not the other way around. However, you can get there if you "go around the block".  Select the tabulate output with the selector tool, paste into word, copy from word to excel.  Not ideal for repetitive tasks but it works (at least on a Mac ).

View solution in original post

2 REPLIES 2
KarenC
Super User (Alumni) KarenC
Super User (Alumni)
Solution

Re: Wouldn't it be nice to export tabulate to excel with header rows as hierarchies

Jul 30, 2015 03:24 PM (13808 views)  |  Posted in reply to message from saitcopuroglu 07-30-2015

Hmm, I am always trying to get data out of excel and into JMP, not the other way around. However, you can get there if you "go around the block".  Select the tabulate output with the selector tool, paste into word, copy from word to excel.  Not ideal for repetitive tasks but it works (at least on a Mac ).

saitcopuroglu
saitcopuroglu
Level IV

Re: Wouldn't it be nice to export tabulate to excel with header rows as hierarchies

Jul 31, 2015 10:02 AM (10774 views)  |  Posted in reply to message from KarenC 07-30-2015

Thank you, it really is not for repetitive tasking but it works (luckily I am on Mac also).

Actually there are many managers in the company who would like to play with the data as they wish (sort, formulate, format) so excel is still a must for them. hi-tech but untouchable html5 output is not an output for them, 'it is only a picture' as they say...

I wish the beloved developers hear my dreams and they make it one day come true

Many thanks again!

0 Kudos

Recommended Articles