You can split data by selecting the column containing the data you want to split and then using the ‘Split Column’ option from the ‘Transform’ tab in the Power Query Editor.

Learn how to use Excel Power Query's extract and split column features to extract delimited strings into their components.