Comma Separated Cell Values to Column of Unique Cell Values

step 1
i have one column of data. there are currently ~10k rows, but this will increase over time. each row has either a single value (example: pepsi) or a comma separated value (google,samsung) with up to 6 commas. instead of the rows looking like this:

pepsi
google,samsung
coca-cola

i want them to look like this in one column (preferably via a formula):

pepsi
google
samsung
coca-cola

step 2
i would like the above output to be a unique, alphabetized list. i think i have a formula that will work for this, but if there is a way to do this all at once, i'm all ears. again, i'd prefer a formula.

any help is appreciated on either of these steps! i've been trying this a few different ways, and i'm not sure this is the best one.

Please see attached file with formula entered in B2 and dragged across and down.

I couldn't come up with one formula solution for this task. In the attached sheet you will see an alternative where data first extracted as it was suggested in first post and then combined in one column (see column K for formula).

Copy and paste values from Column K into this attached macro-enabled sheet in A2 and press the button. It will extract unique values in alphabetical order.

It is not possible to do all that you want with a single formula in one column.

You could get this list with one formula:

pepsi
google
samsung
coca-cola

Then, you would need another formula to get the sorted list:

coca-cola
google
pepsi
samsung

However:

there are currently ~10k rows, but this will increase over time.

The formulas needed to do this are very calculation intensive and on 10k+ rows of data it might negatively impact the performance of your file.