#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).group(-Score).([#]|~.(Name))",Sheet1!A1:B25)

Code explanation:

Group by Score and sort in reverse order; loop through each group, and merge the group number and the name of students in the group into a sequence.

---

Download esProc Desktop for FREE and level up your Excel skills now!! 🚀✨⬇️

✨SPL download address: esProc Desktop FREE Download

✨Plugin Installation Method: SPL XLL Installation and Configuration

✨References to other rich Excel operation cases: Desktop and Excel Data Processing Cases

✨YouTube FREE courses: SPL Programming