Need to remove null values after rotating column

[Yo421]

Hello,
I have an excel file (txt) with printer counters that I need to format to import it into a tracking tool.
I only need the "Machine Num, Counter Date, Counter Type and Counter Value columns".
My problem is that I have to rotate the counter type column to have the ZBWT (black counter) and ZCOT (Color counter) values in the column and group the serial numbers of my printers (Machine number).
Can you help me with the attached file?

Thanks

 

[Belleke]

I don't know ,Is this te result dat you want?
I guess that you mean with rotate ,transpose.
Maybe post a small example with the result that you want.
I do understand French

 

[Yo421]

Thanks for your help.
In attached the result i'dlike to have.

Thanks

 

[Belleke]

Tableau pivot?

 

[Yo421]

Thank you for this feedback.

I need to generate a .csv file formatted according to the "Resultat-souhaite" file in order to be able to integrate it into our invoicing tool.