How does Excel group scattered data bars to the left?

<> as shown in the figure above, first select all the data regions, press CTRL+G, select the targeting, select the null value, then right-click to select Delete, and select the right cell to move left.

In addition to VBA, the more practical solution I can think of is the selective paste.

Select the rightmost column of data and copy it.

Select the second column of data from the right, right-click, and paste Special (as shown in the figure below).

3.Check "Skip empty cells" and click "OK" (as shown in the figure below);

4.Then select the current column (the second column from the right) and copy it.

5.Select the third column from the right and repeat the steps;

6.Up to the leftmost column.

1. Select the blank whole column, right-click, select Delete, it will pop up to the left to delete and move, or move like up, select the one you want.

2. Do three columns three times.

3. Copy and paste the last two columns to the first column.

You want to keep the vertical bars intact and clustered to the left, and you can only manually shift them. It's hard to tell how long your vertical strip is.

Let's see if other friends can help you.

The above formula is processed column by column, to determine whether the current cell data is empty, if it is, copy the data on its right, skip it if it is not empty, and execute it column by column from left to right.

It's a bit big. It seems that it is very troublesome to use VBA...

How excel moves scattered columns of data cells to the left.

Isn't it good to insert and then copy-paste.

In addition to VBA, the more practical solution I can think of is to choose which slag to paste.

Select the rightmost column of data and copy it.

Select the second column of data from the right, right-click the mouse beam bend mark, and "Paste Special" (as shown in the following figure);

3.Check "Skip empty cells" and click "OK" (as shown in the figure below);

4.Then select the current brother boring column (second column from the right) and copy;

5.Select the third column from the right and repeat the steps;

6.Up to the leftmost column.