Split a column of text (Power Query)
You can split a column with a text data type into two or more columns by using a common delimiter character. For example, a Name column that contains values written as <LastName>,
<FirstName> can be split into two columns using the comma (,) character.
Note: Power Query is an Extract Transform Load (ETL) tool. It allows us to Download and fetch data from different sources. We call this data ingestion Combine, clean, and model this data. We call this data wrangling Reference:
https://support.microsoft.com/en-us/office/split-a-column-of-text-power-query-5282d425-6dd0-
46ca-95bf-8e0da9539662