Dataview - Flatten problem with grouped and sorted table

Hi all! I have a table with musical bands grouped by Use (Party, Training, Test, Relax, etc) and/or a combination of both.

I was trying a lot of things, but I feel the problem is fundamental thing.

File estructure (YAML)

---
Use: 
Songs: Sleep in the snow, Southern air, Keeper
Highlighted: 
---

What I tried to do

'''dataview
 TABLE WITHOUT ID rows.file.links as Band, Song, Use, Highlight, Collaboration
 FROM <path>
 SORT file.mtime ASC
 FLATTEN Rows
 GROUP BY Use
 SORT ROWS
'''

:heavy_check_mark: = Achieved
:x: = Not achieved

What I’m trying to do

  • Table without id (first column is rows.file.link as Band) :heavy_check_mark:
  • Sort Alphabetically Ascendant (inside the group) :heavy_check_mark:
  • Grouped by Use :heavy_check_mark: and Sort Alphabetically Ascendant :x:
  • Flatten by Use :heavy_check_mark:
  • Showing Songs, Highlighted and Collaborations :x:

Example

Band Song Use Highlight Collaboration
prev. bands other uses
A-Band #1 Songs, … Party [[Band]], …
B-Band #2 Songs, … Party Highlight [[Band]], …
C-Band #3 Songs, … Party
A-Band #4 Songs, … Relax [[Band]], …
B-Band #5 Songs, … Relax Highlight [[Band]], …
C-Band #6 Songs, … Relax
D-Band #7 Songs, … Relax, Training
A-Band #8 Songs, … Test Highlight [[Band]], …
B-Band #9 Songs, … Test, Relax [[Band]], …
post. bands other uses

Extra question

  • It’s possible to separate the multiple uses (like Relax, Training) in two separate D-Band #7 rows? like:
    Band Song Use Highlight Collaborations
    D-Band #7 Songs, … Relax [[Band]], …
    D-Band #7 Songs, … Training [[Band]], …

Thanks a lot beforehand! :kissing_heart: