Cleaning excel data and putting in table using macros/VBA
$30-100 USD
Cerrado
Publicado hace casi 15 años
$30-100 USD
Pagado a la entrega
Using VBA in Excel, need to do the following to long lists of? raw? data copied and pasted? from a website:
1) remove empty rows
2) remove unwanted text from row values
3) remove duplicates
4) complete series of "if, then" tests to create? several? columns containing the below data, data which is currently in only one column:
? ? ? ? a) product name
? ? ? ? b) product weight
? ? ? ? c) indicate if special promotion
? ? ? ? d) price
## Deliverables
I? can send? an excel file with examples of the raw data.?
You could write the VBA code directly in this file.