Power Query transformations can assist in splitting data into rows, based on various factors such as delimiter, text patterns, and data types.

Google Sheets overrides the original data. If you want to use full names later, copy the rows, paste them to another column or sheet, and run the Split text to columns function.