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

Problem description & analysis: Here below is a data table: Task: Now we want to convert it to a row-based table, like this: Solution: Use SPL XLL and enter the following code: =spl("=E(?1).pivot@r(Names,Sales;Weekday,Day).new(Names,Sales,Day).sele...