Work in export EXCEL table, ABC columns each list of words, there are Spaces, Spaces are not equal, how to realize the text part of automatic batch merger blank cell down, thought for a long time can not solve, consult everybody have a good way to achieve!!!!!

CodePudding user response:

Didn't understand what goal, when use what means to

CodePudding user response:

I'm sorry, not clear, I send a picture, the columns of the data is too much, manually merge eyes are spent, can automatically realize this in some way as a result, a great god, please give advice or comments!

CodePudding user response:

"Filter" function "is not empty" line is not ok, permanent, select blank line is deleted, must merge, may want to use vba macro code.

CodePudding user response:

This is just one part of the table of contents, the other parts of the column Spaces are content, so can't use screen!