Integration of text columns

HansVogelaar 

The attached version of your workbook could demonstrate that it is always possible to make a topic more complicated, given the right tools!  My formula

= Table1Restructured

clearly hides more than it exposes, but in detail it could be

able1Restructured = LET(
    distinct,UNIQUE(Table1[[Name]:[Email]]),
    distinctName, TAKE(distinct,,1),
    activities, MAP(distinctName,
        LAMBDA(n,
            TEXTJOIN(", ",,FILTER(Table1[Activity],Table1[Name]=n))
        )
    ),
    HSTACK(distinct, activities)
)

Of course, each of the methods will get that much more complicated if one allows for different email addresses to appear against a single name.