How to remove column data and shift other column

Hi Team
i m having a sheet and and i need to remove the data in the red side and shift the data in green aside as shown in the 2 end row

how should i delete multiple column data at onces and how do i shift the data to left side

Hi there,

What I did was replacing the columns on the left with the columns on the right and then fill remaining columns with empty values.

I attached a sample:
Main.xaml (12.7 KB)

1 Like

Thank you @alexandretperez it worked

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.