Hi Team,
I have below sample dataset. I have posted the sample data for 2 years. but in Actual I am having the dataset for 10 years. So I am looking for the suggestions to remove empty rows and columns. Data cleansing tool I know but it's not working in every conditions as I have the data in excel file.
First step is to get the headers which i can achieve it using dynamic rename tool.
| F1 | F2 | F3 | F4 | F5 | F6 | F7 | F8 | F9 | F10 | F11 |
| Year | | Q1 2019 | Q2 2019 | Q3 2019 | Q4 2019 | | Q1 2020 | Q2 2020 | Q3 2020 | Q4 2020 |
| | | | | | | | | | | |
| Roll no | | 0 | | 0 | | | | 0 | | 0 |
| Age | | | 0 | 0 | | | | | | |
| sub 1 | | | | | 0 | | 1 | | 2 | |
| sub 2 | | 1 | | | | | | 8 | | |
| | | | | | | | | | | |
| sub 3 | | | 2 | | | | | 3 | | 0 |
| sub 4 | | | | 4 | | | | | 0 | |
Could you please help me to achieve the same.
Many Thanks in advance 
