When you convert your data set into a table range, the insert column method losses some of its functionality.
For example, you cannot insert non-adjacent columns in one go as you do in a normal data set by selecting the non-adjacent columns to insert columns to the left of them.
In table range, if you want to insert multiple non-adjacent columns, you need to do it one by one.
First, click on any cell in the column and right-click.
Now, click on the “Insert” option from the pop-up and then select “Table Columns to the Left”.
At this point, the column has been inserted to the left of your selected cell.
To insert the adjacent multiple cells, First, you need to select the multiple adjacent columns.
Now, click on the “Insert” option from the pop-up and then select “Table Columns to the Left”.
At this point, two columns have been inserted to the left of your selected cells.