Text to Columns writes over the original data. Your data might not be in Excel, and although Power Query is available in Excel, Power Query can import data from lots of sources — not only Excel.

Compared to other clustering techniques, DBSCAN does not require you to explicitly specify how many data clusters to use, explains Dr. James McCaffrey of Microsoft Research in this full-code, ...

A shared Microsoft 365 Lists list is more valuable if you can use it to update source data in Microsoft Excel.