I have a master table that is 4000+ rows. I created a subtable for Measure Code AM1_2 to share here. I created the master table by combining a separate table for each of the years represented in the column headings. When I did this I noticed that years 2009 and 2010 had named the measure codes with hyphens (AM1-2) and the remaining years had used the underline (AM1_2). The underline is the preferred naming convention so I corrected the 2009 and 2010 measure codes and the end result is as you see it in Book 2, attached. Now my job is to collapse the rows, or merge or join - whatever I need to do to get each measure on one line spanning all years. Not all measures span all years as you can see in my original screenshot for Measure code AM1_1. The problem is 2009/2010 versus the remaining years, in all Measure Codes, because of the original difference in naming the measures for those years.

I think there are going to be other problems going forward - I am looking at the percentages (%) in the 2009 and 2010 columns, wondering if that's why conditional formatting isn't working. But first things first - fixing the rows.

I am an Excel newbie, unfortunately, and this seems to be a complicated project to begin with. Usually I can browse around and visit some tutorials and get acquainted with a program without being reliant on someone else coming to the rescue. Excel is going to be my exception. I appreciate every bit of help you can give. Thanks!

Edit: I don't know what "before and after" would be referring to - this is the before, and I want to get to the after - unless you want to see the table before I corrected the measure names?

Attached Files

Book2.xlsx (15.2 KB, 11 views)