Remove White Space

[narendran4u]

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

[binuacs]

@narendran4u Can you provide a sample input file and expected output?

[alex]

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.

[narendran4u]

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)

[narendran4u]

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