select B.fecha, B.parte,
(select A.total
from TuTabla A
where B.fecha=A.Fecha
and B.parte=A.Parte
and A.dia='01') as dia1,
(select A.total
from TuTabla A
where B.fecha=A.Fecha
and B.parte=A.Parte
and A.dia='02') as dia2,
(select A.total
from TuTabla A
where B.fecha=A.Fecha
and B.parte=A.Parte
and A.dia='03') as dia3
from TuTabla B
Group By B.Fecha, B.Parte