How to change long format into wide and add new derived variable based on the original rows

I have a long table format and try to construct a wide format that contains additional variables based on the rows.