Hi

How can the left structure be transformed into the right one?

The 'school' indicates school id.
The 'open' means the year of establishment.

The variable name of 'open' in the output table (right) can be different.

Array