Hello fellas,
I have over 60000 rows of data in excel 2010.
Each row have unique client name
like I have 4 client names I want to keep the same as their real name in Client placeholder to automate column. I have another 40 clients like John and David that I want to assign them Other in Client placeholder to automate column. Is there a way to do it??
Thanks in advance.
<tbody>
</tbody>
I have over 60000 rows of data in excel 2010.
Each row have unique client name
like I have 4 client names I want to keep the same as their real name in Client placeholder to automate column. I have another 40 clients like John and David that I want to assign them Other in Client placeholder to automate column. Is there a way to do it??
Thanks in advance.
Client name | Client Placeholder to automate | ||
ABC | ABC | ||
ABC1 | ABC1 | ||
ABC2 | ABC2 | ||
John | Other | ||
David | Other |
<tbody>
</tbody>