How to transpose rows to column mysql 8.0.29 using phpadmin

Question

SELECT Item,SUM(Qty) as Qty,Due_date,
(CASE WHEN (DATEDIFF(Due_date, CURRENT_DATE)<=-90) THEN '90+ Days'
WHEN (DATEDIFF(Due_date, CURRENT_DATE)>-90 and DATEDIFF(Due_date, CURRENT_DATE)<-60 ) THEN '61-90 days'
WHEN (DATEDIFF(Due_date, CURRENT_DATE)>=-60 and DATEDIFF(Due_date, CURRENT_DATE)<-30 ) THEN '31-60 days'
WHEN (DATEDIFF(Due_date, CURRENT_DATE)>=-30 and DATEDIFF(Due_date, CURRENT_DATE)<-15 ) THEN '16-30 days'
WHEN (DATEDIFF(Due_date, CURRENT_DATE)>-15 and DATEDIFF(Due_date, CURRENT_DATE)<-7 ) THEN '8-15 days'
WHEN (DATEDIFF(Due_date, CURRENT_DATE)>=-7 and DATEDIFF(Due_date, CURRENT_DATE)<=0 ) THEN '0-7 days'
 
WHEN (DATEDIFF(Due_date, CURRENT_DATE)>0 ) THEN WEEK(Due_date)
END ) AS Dues

FROM orderdata 
GROUP by Item,Dues 
ORDER BY Item,Due_date;  

Table 1

need dues to pivot and group by item