csv - Change an excel sheet to be formatted differently

Question

I'm not really sure of the proper terms here so I didn't know how to search for an answer.

I have a csv file with information presented in the following way:

Carrier	State
Aetna Health and Life Insurance Company (AHLIC)	IOWA
Aetna Health and Life Insurance Company (AHLIC)	ARIZONA
Aetna Health and Life Insurance Company (AHLIC)	UTAH
Aetna	CALIFORNIA
Aetna	TEXAS
Aetna	IDAHO
Humana	UTAH
Humana	FLORIDA
Humana	GEOLRGIA

question from:https://stackoverflow.com/questions/65602399/change-an-excel-sheet-to-be-formatted-differently

Answer 1

If you have access to the new array formulas

To get your list of unique values in the first column

=UNIQUE(A2:A10)

And to join the values associated with each unique value

=TEXTJOIN(", ",TRUE,FILTER(B:B,A:A=D2,""))

---