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
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