Transpose rows to columns dynamically, during which target column names are generated by dynamically computing records and fill all data in the new table sequence.
One task is to get information of each employee’s all sources of income, during which category values are automatically generated, according to Income table.

Each employee may have different sources of income. Below is the desired result:

For row-to-column transposition where row values cannot be predetermined, the number of rows and their names also cannot be pre-decided. In this case pivot() function is useless, we need to write code to perform the dynamic transposition instead.

SPL script:

A3 After the Income table is grouped, make the maximum number of members in a group the number of columns, dynamically generate column names and create a table sequence.
A4~B5 Loop through each group to concatenate name, income sources and income amounts into a sequence, and insert them into A3’s table sequence.