Forum Discussion
Regrouping Data in single row
Hi Everyone, I've been struggling with an issue and can't find the answer using an AI excel chatbot... So sorry if this thread has already been addressed but I find it quite hard to formulate. Fi...
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)
)