VALUE_ID      VALUE_TX       FIELD_NAME     Version_ID
      1          Yes             Adult           1
      2          18              Age             1
      3          Black           Eye Color       1
      4          Yes             Is_Adult        2
      5          25              Years_old       2
      6          Brown           Color_of_Eyes   2

Version_ID   Version_Name
     1         TEST_RUN
     2         REAL_RUN

Submitted_Name    Adult?     Age     Eye_Color
     TEST_RUN       Yes        18      Black
     REAL_RUN       Yes        25      Brown

SELECT * FROM (
                  select value_Tx, field_name, version_id
                    from VALUE
                )
          PIVOT (max (value_tx) for field_name in (('Adult', 'Is_Adult')   as 'Adult?', ('Age', 'Years_old') as 'Age', ('Eye Color', 'Color_of_Eyes') as 'Eye_Color')
           );