Pivot one column related to multiple columns

Hi all, and thanks in advance for the support,

I have collected data from a Sharepoint Online List, and as it is getting the data from power apps, we are getting different results for every day, meaning we can have multiple registers for the same date, depending on the machine (#01, #02...) used. My idea would be to convert the machine colum to multiple columns, and join the data so in the end I only have 1 row for each day. 

This is how I have it now: 

And I was thinking to have it like:

Were every "#0..." corresponds with the machine, and the value would be the Hour-meter and Machine hour values. 

I've tried pivoting the columns but then it would put the Machines in columns, but still maintain differente rows for each day, and just add "nulls" if it doesn't match with the machine measured:

That would apply both for Hour-meter and Machine-hour columns.

PD: I don't know if this is the best solution, as I know I can work with the data as it is now, but they had it set up this way with the old solution.

Thanks for the help 🙂