Old Way vs One Formula! Excel Magic with LET + TEXTJOIN 💡

Описание: Still using two columns to group and join values in Excel? 🚫
Watch how ONE powerful formula using LET, UNIQUE, MAP, and TEXTJOIN replaces the old method — cleaner, smarter, and fully dynamic! 🔥
Formula:
LET(
countries, A2:A26,
vehicles, B2:B26,
uniqueCountries, UNIQUE(countries),
header, {"Country","Vehicle Names"},
data, HSTACK(uniqueCountries, MAP(uniqueCountries, LAMBDA(c, TEXTJOIN(", ", TRUE, FILTER(vehicles, countries=c))))),
VSTACK(header, data)
)