TABLE JOIN & PIVOT PROBLEM IN USE CASE

I want to make a table like this..

We have 2 tables.

 

COL1 COL2 COL3 COL4 COL5
M1 L1 01 PARA1,PARA2,PARA3,PARA4 1.0,1.1,1.2,50.3
M1 L1 02 PARA1,PARA2,PRAR3 5.4,3.4,2.3
M2 L2 01 PARA2,PARA3,PARA5,PARA6 1.1,2.2,3.3,4.4
M2 L2 02 PARA7,PARA8,PARA9,PARA2 3.3,4.4,5.5,6.6

 

COL1 COL2 COL3 COL4 COL5
M1 L1 01 OP1_PARA1 5.6
M1 L1 02 OP1_PARA2 4.5
M2 L2 01 OP2_PARA1 4.5
M2 L2 02 OP2_PARA2 5.6

 

COL1, COL2, COL3 : Unique Index

COL4, COL5  PARA and Value are matched, respectively

 

When we pivot using 2 tables, aggregation function is AVG or MEDIAN.

 

Final goal is to make a one table like this format.

COL1   COL2   COL3  PARA1   PARA2  PARA3  PARA4  PARA5  PARA6 PARA7 PARA8  PARA9  OP1_PARA1  OP2_PARA2 OP2_PARA1 

OP2_PARA2

 

what kind operator we can use it...?