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: 
The Discovery Summit 2025 Call for Content is open! Submit an abstract today to present at our premier analytics conference.
Choose Language Hide Translation Bar
dwaterson
dwaterson
Level III

How do I fill in blank cells in a column without creating a new column? For example, filling in blank cells with "NA".

Jul 25, 2014 01:24 PM (13435 views)

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?

0 Kudos
1 ACCEPTED SOLUTION

Accepted Solutions
Jordan_Hiller
Staff Jordan_Hiller
Staff
Solution

Re: How do I fill in blank cells in a column without creating a new column? For example, filling in blank cells with "NA".

Jul 25, 2014 02:07 PM (17193 views)  |  Posted in reply to message from dwaterson 07-25-2014

Hi dwaterson,

Try recoding the blanks to "NA" in place. Select the column in the data table, then choose Columns > Recode. It's self explanatory from there.

Cheers,

Jordan

View solution in original post

1 REPLY 1
Jordan_Hiller
Staff Jordan_Hiller
Staff
Solution

Re: How do I fill in blank cells in a column without creating a new column? For example, filling in blank cells with "NA".

Jul 25, 2014 02:07 PM (17194 views)  |  Posted in reply to message from dwaterson 07-25-2014

Hi dwaterson,

Try recoding the blanks to "NA" in place. Select the column in the data table, then choose Columns > Recode. It's self explanatory from there.

Cheers,

Jordan