u/Adramelk

Hello.

Would appreciate if anyone can me lead me to how can I format the table in picture 1 into picture 2. The pictures are a simplification of the overall data that I have, which has around >300 rows.