How to create vendor list of WHITE VENDORS | PRIME VENDORS

How to create vendor list of WHITE VENDORS | PRIME VENDORS
How to make white vendor list
How to use excel to create email ids as per format
Excel sheet trick to make email ids
American vendors email id collection
How to make email ids of American companies