I'm not sure if this would require a custom function of some sort or can be done with builtin functions
If I have some columns
Item | Section
a | 1
b | 1
c | 2
d | 1
e | 2
and then I want to make a column that dynamically looks like:
Section 1
a
b
d
Section 2
c
e
That column has columns to the left and right that shouldn't change. Just the number of cells for each section should be dynamic based on the data from the first columns, so as things are moved from one section to another the sections resize themselves