To get started, open the Excel Sheet in which you would like to split a single column into multiple columns. Then, go to the ‘Data’ tab and select the ‘Text to Columns’ section.

A table in Excel's Power Query Editor, with a column being renamed 'Month', and the data type symbol representing a calendar.