DF value by Column... not sure what to call it

[tester_V]

I'm probably overstaying my welcome but I'd like to ask one more question.
Here is an Excel file:
Cars Sold, Employee Name,
Cadillac CTS, Bill Clinton,
Cadillac XT6, Bill Clinton,
Cadillac Escalade, Bill Clinton,
Mercedes-Benz E-Class, Hillary Clinton,
Mercedes-Benz E-Class E450, Hillary Clinton,
Ford Expedition, Monica Lewinsky,
Ford F-150, Monica Lewinsky,
Ford Pinto, Monica Lewinsky,
Ford Mustang Mach e, Monica Lewinsky,

I’d like to create the file for each Employee with the cars sold.
Each file should have the name of the Employee.
Bill_Clinton.txt
Hillary_Clinton.txt
Monica_Lewinsky.txt
Could you tell me how I filter these things?
Thank you.