title: how to remove na without deleting the whole row
body: <p><a href="https://i.stack.imgur.com/mXaxN.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/mXaxN.png" alt="enter image description here"></a>how do i remove the na's from the final out with out deleting the whole row </p>
  
  <pre><code>library(dplyr)
  library(plyr)
  library(tidyverse)
  library(readxl)
  library(ggplot2)
  library(datasets)
  library(formattable)
  library(flextable)
  library(xlsx)
  file.list &lt;- list.files(pattern='*.xlsx',recursive = TRUE)
  file_names&lt;-sapply(file.list,read_excel,simplify = FALSE)
  df1&lt;-rbind.fill(file_names)
  vf1&lt;- select(df1,"Location Address",City,State,ZIP,address1,address2,city,state,zip)
  df1&lt;-unite(vf1,'Full Address',"Location Address",City,State,ZIP,address1,address2,city,state,zip,sep = ",")
  newdata&lt;-na.omit(df1)
  write.csv(newdata,"adv134.csv",row.names =FALSE)
  </code></pre>