Data Cleaning in Microsoft ExcelKondal Rao
Client provided me with a messy data in which all the matter was wriiten in a single column. His requirement was to clean the data and put the texe & values in separate clolumns.
Below is the process I applied to clean the data.
Select the column neat the given data
Entered the first data given
using the AI feature CTRL+E I filled the data down the whole column
In this way I cleaned the whole data
Kondal's other services
Starting at$10
Duration1 day
Tags
Data cleaning
Micosoft Excel
Service provided by
Kondal Rao Raipur, India
Data Cleaning in Microsoft ExcelKondal Rao
Client provided me with a messy data in which all the matter was wriiten in a single column. His requirement was to clean the data and put the texe & values in separate clolumns.
Below is the process I applied to clean the data.
Select the column neat the given data
Entered the first data given
using the AI feature CTRL+E I filled the data down the whole column
In this way I cleaned the whole data
Kondal's other services
$10