topic How do I fill in blank cells in a column without creating a new column? For example, filling in blank cells with &quot;NA&quot;. in Discussions https://community.jmp.com/t5/Discussions/How-do-I-fill-in-blank-cells-in-a-column-without-creating-a-new/m-p/9029#M8990 <HTML><HEAD></HEAD><BODY><P>I have a data set that collects information from a process. There are cases when the information is not typed into the collection interface that results in blanks for that data column. I would like to fill those blanks with "NA" so they appear in the distribution analysis. Is there a way to do this without creating a whole new column?</P></BODY></HTML> Fri, 25 Jul 2014 17:24:41 GMT dwaterson 2014-07-25T17:24:41Z How do I fill in blank cells in a column without creating a new column? For example, filling in blank cells with "NA". https://community.jmp.com/t5/Discussions/How-do-I-fill-in-blank-cells-in-a-column-without-creating-a-new/m-p/9029#M8990 <HTML><HEAD></HEAD><BODY><P>I have a data set that collects information from a process. There are cases when the information is not typed into the collection interface that results in blanks for that data column. I would like to fill those blanks with "NA" so they appear in the distribution analysis. Is there a way to do this without creating a whole new column?</P></BODY></HTML> Fri, 25 Jul 2014 17:24:41 GMT https://community.jmp.com/t5/Discussions/How-do-I-fill-in-blank-cells-in-a-column-without-creating-a-new/m-p/9029#M8990 dwaterson 2014-07-25T17:24:41Z Re: How do I fill in blank cells in a column without creating a new column? For example, filling in blank cells with "NA". https://community.jmp.com/t5/Discussions/How-do-I-fill-in-blank-cells-in-a-column-without-creating-a-new/m-p/9030#M8991 <HTML><HEAD></HEAD><BODY><P>Hi dwaterson,</P><P></P><P>Try recoding the blanks to "NA" in place. Select the column in the data table, then choose Columns &gt; Recode. It's self explanatory from there.</P><P></P><P>Cheers,</P><P>Jordan</P></BODY></HTML> Fri, 25 Jul 2014 18:07:47 GMT https://community.jmp.com/t5/Discussions/How-do-I-fill-in-blank-cells-in-a-column-without-creating-a-new/m-p/9030#M8991 Jordan_Hiller 2014-07-25T18:07:47Z