I have an excel spreadsheet that has prospect data. It will list the prospect many times based on how many policy types the prospect has. What I need to do is merge the data together based on the prospect name and have the policy type, expiration date, premium, company, producer and status from each row become 1 record per prospect. The best thing to do is look at the attached example. The first tab is the original and teh second is what I want it to look like. this is a sample of the spreadsheet. The actual one has over 3200 records total.
This needs to be done immediately!!!