Forum Discussion

Virago's avatar
Virago
Copper Contributor
Aug 10, 2026

Sorting column groups having shared rows?

I recently organized a spreadsheet representing participants in a Ham Radio group. Though there is a base group of regular participants, we often have new folks joining us. I like to maintain a list ...
excel
IlirU's avatar
IlirU
Iron Contributor
Aug 11, 2026

Hi Virago​,

In cell F1 I have applied this formula (see the screenshot):

=LET(
     data, A1:.D200,
      arr, ARRAYTOTEXT,
    w_col, WRAPCOLS(BYROW(DROP(data, 1), arr) & ", ", 12),
           DROP(VSTACK(TEXTSPLIT(arr(TOROW(IFNA(EXPAND(BYROW(TRANSPOSE(TEXTSPLIT(TEXTJOIN(";",,
                       REPT(TAKE(data, 1) & ",", COLUMNS(w_col))), ",", ";", TRUE)), arr),, 2), ""))), ", "),
                  TEXTSPLIT(TEXTJOIN(";",, BYROW(w_col, arr)), ", ", ";")),, -1)
)

Try it and let me know.

IlirU