At first glance, this look really easy. All you need to do is select E2:H2, right click, select Delete..., and then Shift cells up.

Unfortunately, there is a single Provider Number, 381319, among the data you provided which only has one record so when you do the above, its data is shifted to the preceding Provider Number, 381318. See attached.

Is that going to be a problem? If so, we can fix that. If not, then all you need to do now is delete all the rows with no data. That is easily done by a quick sort and delete.

One thing I've noticed though, the data for 2009 and 2010 are percentages. The subsequent data are not.

Attached Files

Book2.xlsx (12.5 KB, 9 views)