MySQL 8.0

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

CREATE TABLE dr_machine(
   mID           INTEGER  NOT NULL 
  ,Code          INTEGER  NOT NULL
  ,sawing_Type VARCHAR(100) NOT NULL
  ,section       VARCHAR(100) NOT NULL
);
INSERT INTO dr_machine
(mID,Code,sawing_Type,section) VALUES 
(1,0058,'Zigzag','L01'),
(2,0065,'Zigzag','L01'),
(3,0089,'Puller','L02'),
(4,1124,'Single Needle','L03'),
(5,8796,'Double Needle','L04');

Records: 5  Duplicates: 0  Warnings: 0


SELECT
mID,  
MAX(CASE WHEN (section='L01') THEN sawing_Type ELSE NULL END) AS L01,
MAX(CASE WHEN (section='L02') THEN sawing_Type ELSE NULL END) AS L02,
MAX(CASE WHEN (section='L03') THEN sawing_Type ELSE NULL END) AS L03,
MAX(CASE WHEN (section='L04') THEN sawing_Type ELSE NULL END) AS L04
FROM 
    dr_machine
GROUP BY 
    mID


mID
L01
L02
L03
L04


1
Zigzag
null
null
null

2
Zigzag
null
null
null

3
null
Puller
null
null

4
null
null
Single Needle
null

5
null
null
null
Double Needle


SELECT
mID,  
MAX(CASE WHEN (section='L01') THEN sawing_Type ELSE '' END) AS L01,
MAX(CASE WHEN (section='L02') THEN sawing_Type ELSE '' END) AS L02,
MAX(CASE WHEN (section='L03') THEN sawing_Type ELSE '' END) AS L03,
MAX(CASE WHEN (section='L04') THEN sawing_Type ELSE '' END) AS L04
FROM 
    dr_machine
GROUP BY 
    mID


mID
L01
L02
L03
L04


1
Zigzag




2
Zigzag




3

Puller



4


Single Needle


5



Double Needle

mID	L01	L02	L03	L04
1	Zigzag	null	null	null
2	Zigzag	null	null	null
3	null	Puller	null	null
4	null	null	Single Needle	null
5	null	null	null	Double Needle