Removing Blank Rows

[kauser]

Hello, 

currently i am summarize a table with input from multiple files. How can i remove blank rows from output table - 

Current Output- 

Items	january	february	march	april	may	june	july	august	september	october	november	december
A		5	6	7	8	9	10	11	12	13	14	15
B	4		6	7	8	9			12			15
C	4	5	6	7	8		10	11	12		14	15
D
E
F
G
H
I		5	6	7	8	9	10	11	12	13	14	15
J	4	5	6	7	8	9	10	11	12	13	14	15
K
L
M
N	4	5	6	7	8		10	11		13	14
O		5		7	8	9	10		12	13		15
P	4	5	6		8	9	10	11		13	14	15

Expecting Output(No Blank Rows) - 

Items	january	february	march	april	may	june	july	august	september	october	november	december
A		5	6	7	8	9	10	11	12	13	14	15
B	4		6	7	8	9			12			15
C	4	5	6	7	8		10	11	12		14	15
I		5	6	7	8	9	10	11	12	13	14	15
J	4	5	6	7	8	9	10	11	12	13	14	15
N	4	5	6	7	8		10	11		13	14
O		5		7	8	9	10		12	13		15
P	4	5	6		8	9	10	11		13	14	15

[Carolyn]

I'm sure there's a better solution, but I would do is:

1. Add a Formula Tool to total January-December
2. Filter where the Total > 0
3. Use a Select to remove the Total column

Another option would be to use a Filter where you say

!isnull(January) and !isnull(February)  ....

for all the months but that seems less than ideal

[flying008]

Hi, @kauser 

You can use Data Cleansing tool to remove null rows. 

[kauser]

Hi @flying008 

can you please provide the workflow for this. this illustration is not clear 

[flying008]

Hi, @kauser 

Due to security policy restrictions, I am unable to upload any WF, so please try it yourself according to the tool process in the animation.

[aatalai]

@kauser take a look at the attached workflow that should do the trick. LEt me know how you get on

[Raj · Accepted solution]

@kauser one way of doing this.