Forum Discussion
Excel Help
I was sent a contact information list & the same name is listed multiple times with different emails. (Each person has more than 1 email address.) If we upload into our system as is, it creates a sep...
This solution might be more than what's needed but it's fun to put together because 365 makes it easier.
ReShape(data)
=LET(
rng, DROP(data, 1),
header, TAKE(data, 1),
name, TAKE(rng, , 1),
uName, SORT(UNIQUE(name)),
email, TAKE(rng, , -1),
organize, LAMBDA(a, v,
LET(records, FILTER(email, name = v, ""), IFERROR(VSTACK(a, HSTACK(v, TOROW(records))), ""))
),
REDUCE(header, uName, organize)
)