look-up values horizontally and reflect them vertically

Hi!

I need help building formula to look up values horizontally and reflect them vertically. I need to reset values from Table into Table 2. In table 2 I only have names of people so I need to reflect their corresponding targets and values vertically.
Table 1
Name Name Value Name Value Name Value
John Target 1 50% Target 2 40% Target 3 10%
Erik Target 4 60% Target 2 20% Target 5 20%

Table 2
John Target 1 50%
John Target 2 40%
John Target 3 10%
Erik Target 4 60%
Erik Target 2 20%
Erik Target 5 20%

Great! Thanks! But why if I click in the cell with the formula, the content disappears then?