1 Line item - 'EMP Train STRONGLY AGREE' = List Item - 'Stongly Agree.....'
2 Line item - 'EMP Train AGREE' = List Item - 'Agree...'
3 Line item - 'EMP Train DISAGREE' = List Item - 'Disagree...'
4 Line item - 'EMP Train STRONGLY DISAGREE' = List Item - 'Strongly Disagree...'
There is a few ways to do this.
I would recommend that you replicate your final module 'TAT Special Staging' to calculate what the final result should be.
Then create a formula that essentially selects the correct line item based on which list item it is for the 'Survey Score'. This will require an IF statement such as IF ITEM(List) = List Item 'Stongly Agree.....' = THEN 'EMP Train STRONGLY AGREE ELSE IF....... to cover all options.
Then import this module into your final module if the import method is what is required as both modules will be the same.
I must say, the dimensionality does look a little odd. What is your ultimate goal?. You do have extra dimensionality for some line items. Metric Name and Processor for example don't change by score, so those line items are taking more space and calculation space than needed
As @usman.zia the simplest way is using an IF. In this case as there are only 4 elements it's OK, but this construct shouldn't be used when you get many, many IFs. You would need to use a line item subset and lookup formula instead
However, I think there is still one piece missing
Is your Metric Type Rank # a formatted list? It looks like this is the other "link" between the two modules
If it is, then you can use a SUM formula for each line item to pull in the values referencing the TAT Satisfaction Rank#