<ul><li>The problem is to convert certain columns of the same row, as group members, to multiple rows.</li><li>The solution involves using SPL XLL and entering specific code to perform the row-column transposition on the data.</li><li>The code utilizes the base columns Names and Sales, transfers other column names as values in the Weekday column, and transfers values in other columns as values in the Day column.</li><li>Specific columns (Names, Sales, Day) are selected, and rows with a non-null value in the Day column are chosen.</li></ul>

#138 — Convert Certain Columns of the Same Row, as Group Members, to Multiple Rows

Discover more