Right-click on a cell in the table Click “Table” and “Convert to Range” Excel will ask you to confirm the change as this will remove the table.

Open Excel and add a new column to the left of the data range you want to convert to a single column.