Converting colums as row
You need a pivoting function. MySQL doesn't have a pivot function per se, you can use conditional aggregation as a workaround.

SELECT
    T.data_item_id,
    MAX(CASE WHEN T.field_name = 'Education' THEN value END) AS Education,
    MAX(CASE WHEN T.field_name = 'Contract or Permanent' THEN value END) AS ContractOrPermanent,
    MAX(CASE WHEN T.field_name = 'Notice period' THEN value END) AS Noticeperiod,
    MAX(CASE WHEN T.field_name = 'Total Experience' THEN value END) AS TotalExperience,
    MAX(CASE WHEN T.field_name = 'Relevant Experience' THEN value END) AS RelevantExperience
FROM
    extra_field AS T
WHERE
    T.data_item_id = 1219 -- Your filter here
GROUP BY
    T.data_item_id


Result:

data_item_id    Education   ContractOrPermanent Noticeperiod    TotalExperience RelevantExperience
1219            MBA         Permanent           30 days         12 yrs          12 yrs


The problem is that you will have to add as many columns and CASE with each different value that you have.

If you need this dynamically (variable amount of columns depending on row's data) you can use prepared statements but it's another level of complexity.