I import data into excel that does not come across clean. In columns A thru D is how the data looks when I import the data into Excel. In columns G thru I is the info I need to extract from the import. As you can see not everyone will have both Meets Expectations or Below Expectations data and if there is no data for one of the categories, I also need the data to tell me zero for that agent. I am not sure how to get the data I need. thanks in advance!!