How to remove Blank space from expression in pivot table?

[hamzabob1]

Hiii All,

Required OutPut:

                                                                                                Fig 1

Qlikview Output:

                                                                                                Fig 2

I don’t want blank row in between the project numbers as shown in fig 1.can u please help me is there any way to suppress the blank space and get the output in required formet.Thanks in advance.

Regards,

Hamza

[qlikviewwizard]

Can you share the sample application

[hamzabob1]

Hii arjun thanks for your rpl..

PFA..

[qlikviewwizard]

hamzabob1

Can you attach the same data as shown in the EXCEL screen data?

[hamzabob1]

PFA.