TEXT in a pivot table

Presently I use Excel to create a horizontal table from a vertical source. That is
Bill Alpha
Bill Beta
Bill Omega
Fred Beta
Fred Tau

Bill Alpha Beta Omega
Fred Beta Tau

Does anybody have any ideas about HOW to do that in Airtable? (which only handles numbers, and NO coverting Single Line Text to Numbers does not work)