extract brand and part numbers from a list

Avg Bid (AUD)
Project Budget (AUD)
$30 - $30

Project Description:
I have a list of 20,000 items in colums a and b tare the part number and the brand I need to extract those and put the part number in coolum c and the brand in column d

Skills required:
Data Entry, Excel
About the employer:
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.