Based on the following assumptions,
1. [responseid] : 1 id stands for 1 people.
2. [Question]: q1-q3 is before, q5-q7 is after. They are pairs, such as, q1 - q5 for Program1.
3. If there is no after answer for a program, the effect is regarded as "same".
I created a sample workbook.
Please refer to the attachment for details.
Sample.twbx 66.3 KB