https://support.google.com/docs/answer/6325535
Split text, remove duplicates, or trim whitespace - Computer - Google Docs Editors Help
Split data into columns You can split clearly defined data, like text separated by commas, into several columns with Google Sheets. For example, a column with...
split textremove duplicatestrim whitespace