How to set data correctly in columns?

[#1]

Hi

I have below data executed from SQL query.

country,  Code, closed,   CY,     CusName,   a1,    a2,      a3,      a4,        a5,         Gender,   ref,       Tori,    Joiuy,   Populate,   int

USA          324         Null    554       XX           ejrlgn  btebte  btbte cvdvdrv   POi O90  M        34758573 vnvjv   POland     jdvsv        Yes

When I am copying and pasting the above values with column headers into excel it is showing output as below

country,  Code, closed, CY,      CusName,   a1,    a2,             a3,      a4,           a5,     Gender,   ref,      Tori,  Joiuy,   Populate,   int

ejrlgn     btebte    btbte   cvdvdrv   POi O90      M     34758573  vnvjv   POland     jdvsv      Yes

Would it be possible to set using Qlikview file. Can anyone suggest me please.

Thanks.

[#2]

I have tried TRIM function but not working for below columns

country,  Code, closed,   CY,     CusName,   a1,    a2,      a3,      a4,        a5,         Gender,   ref,       Tori,    Joiuy,   Populate,   int

please can anyone help me to get this.

[#3]

Please can anyone suggest me would it be possible or not?