Merge SQL MetaData rows into single row with multiple columns

Question

Hello I need help. I am using wordpress plugin Formidable, which saves forms to metadata ( id, item_id, and my values ) … But I have working system which is taking data from DB and working with them. But structure of DB for that system is different. Can you help me to merge data from wordpress into table for my system ?

1. screen is how wordpress saves a data

2. screen is how I need to save data

table is called "list"

Answer 1

screen is how wordpress saves a data

Screenshots are a little bit useless.
Please post table design as DDL, some sample data as DML statement and the expected result.

Answer 2

I have uploaded my data and my expectations of storing this datas here.

file.html