GROUPBY with ARRAYTOTEXT & VSTACK + HSTACK Function in
GROUPBY with ARRAYTOTEXT & VSTACK + HSTACK Function in #Excel 365
=VSTACK({"Names","Units Sold"},
GROUPBY(Data[Names],Data[Units Sold],
ARRAYTOTEXT,,0))
=VSTACK({"Names","Units Sold",""},
GROUPBY(Data3[Names],Data3[Units Sold],
HSTACK(ARRAYTOTEXT,SUM),,0))