I would suggest using <data<Text to columns <delimited with ;
after doing this I would use <edit<goto<special<last cell to identify
the highest column with data.
Sequencially Back to column B, I would sort these columns Cut and paste the
results to the bottom of column A.

"instauratio" wrote:

I have one column that contains 1000 values. The problem is they do not
occupy one value per one cell with 1000 rows.

Some rows/cells have 10 to 15 values, each separated by a semi colon.

How can I sort or filter the entire column and separate each value into it's
own unique cell in one column?