Adding two rows into single row

[#1]

we Have a data (N/A,n/a,1,2,3,4)Group1 (sum of N/A and (blank) rows) 

we show only Group1 in qlikview (sum of two rows (N/A and (blank))) .

=if(Queue like ('N/A'),'Group1',Queue)

[#2]

Here need to comine N/A and - as Group 1

we show only Group1 in qlikview (sum of two rows (N/A and (blank))) .

Have used like operator not getting desired output

[giakoum]

- is the null symbol. Replace null values in your data with Group1 and N/A to get the desired result