MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE TableData_400
 (id INT,
 created_date DATETIME,
 sample_1 TEXT,
 sample_2 smallint,
 sample_3_1 TINYINT,
 sample_3_2 TINYINT,
 sample_3_3 TINYINT,
 sample_4_1 TEXT,
 sample_4_2 TEXT,
 sample_4_3 TEXT

 );
INSERT INTO TableData_400 VALUES
(1,'2019-05-17 06:19:13','aaa',1,1,1,1,'Address1','Address2','Address3');
INSERT INTO TableData_400 VALUES
(2,'2019-05-17 06:19:13','bbb',1,1,0,0,'Address1','Address2','Address3');

select * from TableData_400


id
created_date
sample_1
sample_2
sample_3_1
sample_3_2
sample_3_3
sample_4_1
sample_4_2
sample_4_3


1
2019-05-17 06:19:13
aaa
1
1
1
1
Address1
Address2
Address3

2
2019-05-17 06:19:13
bbb
1
1
0
0
Address1
Address2
Address3


CREATE TABLE TableData_elements
 (Dataid INT,
 sample_id INT,
 sample_title TEXT,
 sample_type  varchar(25)
 );
 
    INSERT INTO TableData_elements VALUES
(400,1,'Name','Text'),
(400,2,'Gender','radio'),
(400,3,'Languages Known','Check Box'),
(400,4,'Address','Address');

select * from TableData_elements where Dataid=400


Dataid
sample_id
sample_title
sample_type


400
1
Name
Text

400
2
Gender
radio

400
3
Languages Known
Check Box

400
4
Address
Address


CREATE TABLE TableData_elements_options
 (Dataid INT,
 sample_id INT,
 option_id INT,
 optionss TEXT               
                   );
 INSERT INTO TableData_elements_options VALUES
('400',2,1,'Male'),
('400',2,2,'Female'),
('400',3,1,'English'),
('400',3,2,'Hindi'),
('400',3,3,'Tamil');

select * from TableData_elements_options where Dataid=400


Dataid
sample_id
option_id
optionss


400
2
1
Male

400
2
2
Female

400
3
1
English

400
3
2
Hindi

400
3
3
Tamil


SELECT 
  CONCAT( 'SELECT ',
          GROUP_CONCAT(CONCAT('sample_',
                              te.sample_id,
                              CASE WHEN teo.option_id>0 THEN
                                    CONCAT('_','teo.option_id')
                                    ELSE '' END,
                              ' ',
                              sample_title)),
          ' FROM TableData_400' )
FROM TableData_elements te
LEFT JOIN TableData_elements_options teo ON  
        teo.Dataid=te.Dataid AND
        teo.sample_id=te.sample_id
        WHERE te.Dataid='400';


CONCAT( 'SELECT ',
          GROUP_CONCAT(CONCAT('sample_',
                              te.sample_id,
                              CASE WHEN teo.option_id>0 THEN
                                    CONCAT('_','teo.option_id')
                          


SELECT sample_2_teo.option_id Gender,sample_2_teo.option_id Gender,sample_3_teo.option_id Languages Known,sample_3_teo.option_id Languages Known,sample_3_teo.option_id Languages Known,sample_1 Name,sample_4 Address FROM TableData_400


expected output will be two tables.

First one 

 id  Dataid   created_date            sample_1  sample_2   sample_4_1     sample_4_2    sample_4_3
 
 1    400          2019-05-17 06:19:13         aaa    1         address1       Address2     Address3
 2    400          2019-05-17 06:19:13         bbb    1         address1       Address2     Address3

second table 

id     sampleid          value
1      sample_3_1         1
1      sample_3_2         1
1      sample_3_3         1
2      sample_3_1         1
2      sample_3_2         0
2      sample_3_3         0
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'expected output will be two tables.

First one 

 id  Dataid   created_date     ' at line 1
id	created_date	sample_1	sample_2	sample_3_1	sample_3_2	sample_3_3	sample_4_1	sample_4_2	sample_4_3
1	2019-05-17 06:19:13	aaa	1	1	1	1	Address1	Address2	Address3
2	2019-05-17 06:19:13	bbb	1	1	0	0	Address1	Address2	Address3
Dataid	sample_id	sample_title	sample_type
400	1	Name	Text
400	2	Gender	radio
400	3	Languages Known	Check Box
400	4	Address	Address