I often extract data, but the data is not coming, need respectively, remove excess empty lines and contains the total row, then add a list before each column column names, and then insert the first line, the line number 1, 2, sorting, deletes data as 1, 2 then delete behavior data, the last is the required data,
Have a master can do?

CodePudding user response:

For example, data cleaning before and after cleaning;