I need to clean a database
I have rows without any data in them throughout my database. Can I do a
simple function to delete the empty rows between my data to clean up my list
in excel.
Second question, on the same database I have an column that consists of name
address city and zip. Is there a way to run a formula to separate these
values into their own rows.
|