title: Repeated rows status based on given rule
body: <p>I have a table like below</p>
  
  <pre><code>        RefNo | Amount | ID |  Billed      
  
          1       20      1      1
          1       20      2      1
  
          2       10      3      0                    
          2       10      4      0 
          2       10      5      0
  
          3       30      6      1                          
          3       30      7      0
          3       30      8      1
          3       30      9      0  
  </code></pre>
  
  <p>I want Out put like below</p>
  
  <pre><code>        RefNo | Amount | ID |  Billed  | Status    
  
          1       20      1      1        SingleBilled
          1       20      2      1        SingleBilled
  
          2       10      3      0        SingleUnBilled            
          2       10      4      0        SingleUnBilled
          2       10      5      0        SingleUnBilled
  
          3       30      6      1        MultipleBilled                  
          3       30      7      0        MultipleBilled
          3       30      8      1        MultipleBilled
          3       30      9      0        MultipleBilled
  </code></pre>
  
  <p>Here Status need to com base on refNo, Billed Flag
  Please help me</p>