Hello,

I've been trying to figure out this problem all night and I just can't
find the answer T.T

Basically,

I have like 3000 rows and 366 columns of data containing only numbers.
I have one column A filled from A1 till A3000, However columns are not
fully filled horizontally.

for an example, Row 1 will have number at colum A, D, and AA.
Row 2 might have number at colum E, F, Z, AB and AC

i.e.
A B C D E F G H I J K ...
1  2         3               1                   0                 2
2       2            3            4            2
3      1                                          8
9           ..
4 1
5  2        4        5
6        2       6          8
7 1
0                                                           8
.
.
.
How do I automatically delete empty cells horizontally so it looks
just like this below?

1 2 3 1 0 2
2 2 3 4 2
3 1 8 9
4 1
5 2 4 5
6 2 6 8
7 1 0 8

Pleae Please HELP

thank you so much!