Re: Regrouping Data in single row

If you're not particular about the desired results with each new costume being in a separate column, GROUPBY can make quick work of this (If you absolutely need the arrangement in your screen cap then a more sophisticated solution can be drawn up). The formula would be even shorter if the row fields needed were positioned left-to-right.

=LET(
    rowfields, HSTACK(DemoTbl[Appointment], DemoTbl[Name], DemoTbl[City]),
    val, DemoTbl[Costume],
    GROUPBY(rowfields, val, ARRAYTOTEXT, , 0)
)