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 |