Cleaning excel data and putting in table using macros/VBA

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.