#136 — Put Data in a Group Horizontally into Columns

Problem description & analysis: Here below is a data table: Task: Rank the students by score, and arrange the names with the same score into the same row. The result is as follows: Solution: Use SPL XLL and enter the following code: =spl("=E(?1).gr...