Data displayed in two lines

Hi,

I am a newbie to both Linux and this forum.

I was trying to pull out the data from a database but it is not showing up in the multiple lines, with my limited knowledge i linux u tried to format this but wasn't exactly getting what i wanted.

The screenshot below shows my problem.

I want this result to be displayed in one line. In other programming languages we can do this by reading each line (till eol character) and display the content line by line. But i am not sure how it is possible in shell scripting.

I look forward to your response.

Thanks
Ninjaa

Try this:

awk '{ORS=NR%2?" ":"\n"}1' file

Regards

Thanks mate!