Hi guys, I've been trying to work around this for a long time and now I'm desperate with a deadline due in a few days, I really need your help I'd appreciate it.
So I have this large Excel file with more than 2000 rows of input data and 6 columns this data is purchase info of supplies needed in a construction company, it goes something like this:
| NAME | UNIT | QUANTITY | PRICE | SUPPLIER | DATE |
|:----:|:----:|:--------:|:-----:|:--------:|:----:|
|Flowguard Plus 2 inch CPVC Pipe|
|Flowguard Plus 2" CPVC|
|CPVC Pipe flowguard plus 2 inch|
|Flowguard plus pipe 2"|
I didn't add any data to rest of columns because is not that relevant the issue comes with the name as the person in charge of feeding this file with input data just copied the name of products as it was printed from invoices.
As you can see the 4 examples in the table above are all the same with different text values.
What I need to do is to sort all of them into the same name for example replace the name of 3 of them so they will all them 4 match text value so it becomes a lot easier to apply functions as count or avarege price.
Is a really large file and all the values are spreaded from the top to the bottom. any ideas?
THANK YOU
Bookmarks