I have summary tables that I want to convert into individual row data. So for example, I have tables like this:
White | proficient | not proficient
reading | 100 | 50
math | 80 | 29
African American | proficient | not proficient
reading | 60 | 45
math | 50 | 75
I want to be able to turn this into three columns:
Race subject Proficiency
With 100 rows of white reading proficient, 50 rows of white reading not proficient, 80 rows of white math proficient; 29 rows of white math not proficient; 60 rows of AA reading proficient, 45 rows of AA reading not proficient; 50 rows of AA math proficient and 75 rows of AA, math not proficient.
I need to do this to a lot of tables.
Is this possible in VBA? I’m a beginner in VBA.
Thanks
Laura
Bookmarks