MySQL 5.6

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE Table1(
ID int NOT NULL,
PTA_1 int NOT NULL,
PTA_2 int NOT NULL,
PTA_3 int NOT NULL,
PTA_4 int NOT NULL,
PTA_5 int NOT NULL,
DTA_1 int NOT NULL,
DTA_2 int NOT NULL,
DTA_3 int NOT NULL,
DTA_4 int NOT NULL,
DTA_5 int NOT NULL
);

INSERT INTO Table1 VALUES(1,1,0,1,0,0,0,1,0,0,0);
INSERT INTO Table1 VALUES(2,1,0,1,0,0,0,1,0,0,0);
INSERT INTO Table1 VALUES(3,1,0,1,0,0,0,1,0,0,0);
INSERT INTO Table1 VALUES(4,1,0,1,0,0,0,1,0,0,0);

CREATE TABLE Table2(
ID int  NOT NULL,
PartNum1 varchar(10),
PartNum2 varchar(10),
PartNum3 varchar(10),
PartNum4 varchar(10),
PartNum5 varchar(10),
DataNum1 varchar(10),
DataNum2 varchar(10),
DataNum3 varchar(10),
DataNum4 varchar(10),
DataNum5 varchar(10)
);

INSERT INTO Table2 VALUES(1,'PTA_1','PTA_2','PTA_3','','','DTA_1','DTA_2','DTA_3','DTA_4','');
INSERT INTO Table2 VALUES(2,'PTA_1','','','','','DTA_1','DTA_2','','','');
INSERT INTO Table2 VALUES(3,'PTA_1','PTA_2','','','','DTA_1','','','','');
INSERT INTO Table2 VALUES(4,'PTA_1','','','','','','','','','');

SELECT * FROM Table1;
SELECT * FROM Table2;

ID	PTA_1	PTA_3	DTA_2
1	1	1	1
2	1	1	1
3	1	1	1
4	1	1	1

ID	PartNum1	PartNum2	PartNum3	DataNum1	DataNum2	DataNum3	DataNum4
1	PTA_1	PTA_2	PTA_3	DTA_1	DTA_2	DTA_3	DTA_4
2	PTA_1			DTA_1	DTA_2
3	PTA_1	PTA_2		DTA_1
4	PTA_1

SELECT t1.ID, t1.column_name, t1.column_value
FROM (
SELECT ID, 'PTA_1' column_name, PTA_1 column_value FROM Table1 UNION ALL
SELECT ID, 'PTA_2' column_name, PTA_2 column_value FROM Table1 UNION ALL
SELECT ID, 'PTA_3' column_name, PTA_3 column_value FROM Table1 UNION ALL
SELECT ID, 'PTA_4' column_name, PTA_4 column_value FROM Table1 UNION ALL
SELECT ID, 'PTA_5' column_name, PTA_5 column_value FROM Table1 UNION ALL
SELECT ID, 'DTA_1' column_name, DTA_1 column_value FROM Table1 UNION ALL
SELECT ID, 'DTA_2' column_name, DTA_2 column_value FROM Table1 UNION ALL
SELECT ID, 'DTA_3' column_name, DTA_3 column_value FROM Table1 UNION ALL
SELECT ID, 'DTA_4' column_name, DTA_4 column_value FROM Table1 UNION ALL
SELECT ID, 'DTA_5' column_name, DTA_5 column_value FROM Table1
) t1
JOIN (
SELECT ID, PartNum1 column_name FROM Table2 UNION ALL
SELECT ID, PartNum2 column_name FROM Table2 UNION ALL
SELECT ID, PartNum3 column_name FROM Table2 UNION ALL
SELECT ID, PartNum4 column_name FROM Table2 UNION ALL
SELECT ID, PartNum5 column_name FROM Table2 UNION ALL
SELECT ID, DataNum1 column_name FROM Table2 UNION ALL
SELECT ID, DataNum2 column_name FROM Table2 UNION ALL
SELECT ID, DataNum3 column_name FROM Table2 UNION ALL
SELECT ID, DataNum4 column_name FROM Table2 UNION ALL
SELECT ID, DataNum5 column_name FROM Table2
) t2 USING (ID, column_name);

ID	column_name	column_value
1	PTA_1	1
2	PTA_1	1
3	PTA_1	1
4	PTA_1	1
1	PTA_2	0
3	PTA_2	0
1	PTA_3	1
1	DTA_1	0
2	DTA_1	0
3	DTA_1	0
1	DTA_2	1
2	DTA_2	1
1	DTA_3	0
1	DTA_4	0