Need Help with pivot function to prevent repeating nulls and attribute column

[Rdata]

I have this table: 

I want this table:

I have no idea how to make it happen. I've honestly tried scouring this forum and digging in google... and nothing seems to cover this particular problem. 

[Rdata · Accepted solution]

My eyes glossed over that first column, not realizing the unique IDs in that column were causing the problem. I got rid of EngieTable_ID and my table works now.