I have an excel file per following attachment. I would like to move non-blank cells to fill starting from the left most cell(column 1). How can I do that?
1 2 3 4 5 6
OXA181 OXA232 OXA OX48
For Example, the tabulation shall become like the following.
KPC NDM CPOTH