Remove White Space

Question

I have to remove the space in between the lines.
I'm getting input file from txt file and need to provide output in text file
Using Union Tool to merge two set of data, where in first set has less number of columns and 2nd set have more number of columns

Capture.JPG

Capture1.JPG

narendran4u · Answer

Input file and Outfile format are similar to picture named "Capture".
On the input file, There is no space inbetween the two lines. 
But on the outfile file, there is space

narendran4u · Answer

I need Row 1 as well, But after Field 8 there was no data available
Also for next rows, there are more number of field
While trying to merge both using "UNION" tool, the null fields in row 1 create a space in text output file(Capture Picture)

alex · Answer

Unclear if you want row 1 removed?  If so then use the filter tool.   Choose a field that would indicate the row doesn't belong.  Field 8 is Null and row 1 would be removed if filtered to Field 8 Is Not Null.