View Single Post
  #1   Report Post  
instauratio
 
Posts: n/a
Default creating a list from a column of semicolon

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?