Assuming your row of interest is stored in an array @row, then

shift @row;
[download]

would remove the first element, ie shift your data by one column to the left, and

unshift @row, "";
[download]

would add an element at the beginning of the array, ie shift your data by one column to the right.

.

You would still need to write the data back into your spreadsheet, I guess, which depends on which modules you are using. Without some of your code this can't be discussed in a meaningful way.