CrossTab tool giving empty rows ( Need some help please !!)

AbhirupMukherjee09

Hi Everyone,

I am looking for a solution to my current problem.

My O/P from the cross-tab tool is coming as

  Name Email     DAY1          DAY2

   A          aa      Present    

   B         bb      Present        

   A          aa                           Present

   B         bb                            Absent.

Used Name and Email in the group by section of Cross Tab, Attendance in the values part and Day column in the header part in the Cross Tab)

Now, I ideally I want to remove those empty values and limit the output to 2 rows only, where the DAY1 & DAY2 values are on the same side. 

I was thinking of using of using a Filter Tool, any have any solution to this type of problem. Please Help 

AbhirupMukherjee09

I have finally found the solution, the Cross Tab  connected with the  Batch Macro (I was using the Cross Tab inside the macro)