13.8 Convert certain columns of the same row, as group members, to multiple rows


Here below is a data table:


Now we want to convert it to a row-based table, like this:




Perform the row-column transposition on the data. The option @r means column-to-row. The Names and Sales columns are used as the base column, other column names are transferred and used as the values in the Weekday column, and the values in other columns are transferred and used as the values in column Day.
Select the columns Names, Sales and Day, and the rows whose value in column Day is nonnull.

esProc Desktop and Excel Processing
13.7 Re-group or sort when filling grouped data into columns
13.9 Convert group formed by every N columns to multiple rows