cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Discussions

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

Use first row as header row

Hi, I have just start using JMP Pro 11. Don't have any experience with JMP but a regular user for SAS. I do have data import question for JMP. I have JMP add-on in excel and using it to bring data into JMP. Once data come into JMP, I do transpose rows into column using "Transpose" option. However, I am unable to find how to convert first row into header row. Suggestions please.

Thanks, Bhupinder

1 ACCEPTED SOLUTION

Accepted Solutions
bwanders
Level III

Re: Use first row as header row

Click on JMP in the Excel toolbar, then click on  "preferences".  You will see where to check the box for "Use first rows as column names"

View solution in original post

3 REPLIES 3
bwanders
Level III

Re: Use first row as header row

Click on JMP in the Excel toolbar, then click on  "preferences".  You will see where to check the box for "Use first rows as column names"

Re: Use first row as header row

These are fixes in excel right.. How to fix this in jmp itself? To be specific, how to change my first row to headers row in jmp itself (I am using jmp 19 version)

Re: Use first row as header row

Got the way. If you already have the data in jmp. Go to "Cols" < "Column Names" < "Move up"

Recommended Articles