majidsiddique
Board Regular
- Joined
- Oct 22, 2018
- Messages
- 164
Dear,
i have problem in excel. how i can remove quickly line delete in S.No column (B). there is a gap between lines, excel can identify automatic gap line and delete them immediately. data is too lengthy. only S.No column(B) is main criteria in a sheet.
<colgroup><col span="2"><col><col span="2"></colgroup><tbody>
</tbody>
i have problem in excel. how i can remove quickly line delete in S.No column (B). there is a gap between lines, excel can identify automatic gap line and delete them immediately. data is too lengthy. only S.No column(B) is main criteria in a sheet.
Item | S.No | Description | Lot | Qty |
12010 | 1 | teri towel | 12111110 | 2 |
2 | teri towel | 12111110 | 2 | |
3 | teri towel | 12111110 | 2 | |
4 | teri towel | 12111110 | 2 | |
5 | teri towel | 12111110 | 2 | |
6 | teri towel | 12111110 | 5 | |
7 | teri towel | 12111110 | 5 | |
8 | teri towel | 12111110 | 5 | |
30010 | 1 | wingles | 2001889 | 6 |
2 | wingles | 2001889 | 6 | |
3 | wingles | 2001889 | 6 | |
4 | wingles | 2001889 | 6 | |
5 | wingles | 2001889 | 7 | |
6 | wingles | 2001889 | 7 | |
7 | wingles | 2001889 | 7 | |
8 | wingles | 8899888 | 9 | |
9 | wingles | 8899888 | 9 | |
40010 | 1 | driver22 | 55551 | 12 |
2 | driver22 | 55551 | 12 | |
3 | driver22 | 66662 | 12 | |
5 | driver22 | 66662 | 12 |
<colgroup><col span="2"><col><col span="2"></colgroup><tbody>
</tbody>