Here below is a data table:

The first row is the country code of each piece of data, the second row is other column names of each piece of data, and the third row is the value corresponding to each column. Now we want to rearrange the data into standard row-based data. The result is as follows:

Script:

A1: Transpose the sequence of sequences, and complement the countries in the first column
A2: Create an empty table sequence (Country,Cate,Value)
A3: Fill in the data of A1 in the table sequence one by one
A4: Use the pivot function to perform row-to-column conversion 

esProc Desktop and Excel Processing
13.3 Convert crosstab to row-based table
13.5 Interconversion of upper layer groups for rows and columns - row-to-column