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.