Setup logical Database model for measurements
From what I understand of your spreadsheet and your description, this is the normalized logical ERD for your data:



Now, based on how many GAP_CATEGORY records you have as a rule, and how many FORCE_SOURCE records you have, you might decide to do some denormalization.  You have to decide what is easier to build, maintain and use and makes more sense in your application.