majidsiddique
Board Regular
- Joined
- Oct 22, 2018
- Messages
- 164
Hi All,
i have a data in below mention table. i want to remove column C (serial) MD-120100000015969 upto MD-14008000000025, not delete 27M888228, can it is possible excel select auto range and remove MD(No)? i am using PIVOT table but all serial are showing.
[TABLE="width: 476"]
<colgroup><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]item[/TD]
[TD]S.No[/TD]
[TD] serial [/TD]
[TD] lot[/TD]
[TD] expiry[/TD]
[TD]Qty[/TD]
[/TR]
[TR]
[TD]MD-120100000[/TD]
[TD] 1[/TD]
[TD]MD-12010000000015969[/TD]
[TD] 2018040079[/TD]
[TD] 30/04/2021[/TD]
[TD] 1[/TD]
[/TR]
[TR]
[TD]MD-120100000[/TD]
[TD] 2[/TD]
[TD]MD-12010000000015970[/TD]
[TD] 2018040079[/TD]
[TD] 30/04/2021[/TD]
[TD] 1[/TD]
[/TR]
[TR]
[TD]MD-120100000 [/TD]
[TD] 3[/TD]
[TD]MD-12010000000015971[/TD]
[TD] 2018040079[/TD]
[TD] 30/04/2021 [/TD]
[TD] 1[/TD]
[/TR]
[TR]
[TD]MD-120100000[/TD]
[TD] 4[/TD]
[TD]MD-12010000000015972[/TD]
[TD] 2018040079 [/TD]
[TD]30/04/2021 [/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]MD-120100000[/TD]
[TD] 5[/TD]
[TD]MD-12010000000015973[/TD]
[TD] 2018040079[/TD]
[TD]30/04/2021[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]MD-120100000[/TD]
[TD] 6[/TD]
[TD]MD-12010000000015974[/TD]
[TD] 2018040079[/TD]
[TD]30/04/2021[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]MD-120100000[/TD]
[TD] 7[/TD]
[TD]MD-12010000000015975[/TD]
[TD] 2018040079[/TD]
[TD]30/04/2021[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]MD-14008000[/TD]
[TD]1[/TD]
[TD]MD-1400800000000021[/TD]
[TD]2018040444[/TD]
[TD]30/04/2021[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]MD-14008000[/TD]
[TD]2[/TD]
[TD]MD-1400800000000022[/TD]
[TD]2018040444[/TD]
[TD]30/04/2021[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]MD-14008000[/TD]
[TD]3[/TD]
[TD]MD-1400800000000023[/TD]
[TD]2018040444[/TD]
[TD]30/04/2021[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]MD-14008000[/TD]
[TD]4[/TD]
[TD]MD-1400800000000024[/TD]
[TD]2018040444[/TD]
[TD]30/04/2021[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]MD-14008000[/TD]
[TD] 5[/TD]
[TD]MD-1400800000000025[/TD]
[TD]2018040444[/TD]
[TD]30/04/2021[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]MD-500DM2700[/TD]
[TD] 1[/TD]
[TD]27M888228[/TD]
[TD] [/TD]
[TD]28/02/2023[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]MD-500DM2700[/TD]
[TD] 2[/TD]
[TD]27M888658[/TD]
[TD] [/TD]
[TD]28/02/2023[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]MD-500DM2700[/TD]
[TD] 3[/TD]
[TD]27M889216[/TD]
[TD] [/TD]
[TD]28/02/2023[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]MD-500DM2700[/TD]
[TD] 4[/TD]
[TD]27M889576[/TD]
[TD] [/TD]
[TD]01/03/2023[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]MD-500DM2700[/TD]
[TD] 5[/TD]
[TD]27M889857[/TD]
[TD] [/TD]
[TD]01/03/2023[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]MD-500DM2700[/TD]
[TD] 6[/TD]
[TD]27M889890[/TD]
[TD] [/TD]
[TD]01/03/2023[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]MD-500DM2700[/TD]
[TD] 7[/TD]
[TD]27M889891[/TD]
[TD] [/TD]
[TD]01/03/2023[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]MD-585210000[/TD]
[TD] 1[/TD]
[TD]MD-58521000000000079[/TD]
[TD] 2018040195[/TD]
[TD]30/04/2021[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]MD-585210000 [/TD]
[TD] 2[/TD]
[TD]MD-58521000000000080[/TD]
[TD] 2018040195[/TD]
[TD]30/04/2021[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]MD-585210000[/TD]
[TD] 3[/TD]
[TD]MD-58521000000000081[/TD]
[TD] 2018040195[/TD]
[TD]30/04/2021[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]MD-585210000[/TD]
[TD] 4[/TD]
[TD]MD-58521000000000082[/TD]
[TD] 2018040195[/TD]
[TD]30/04/2021[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]MD-638RL2600[/TD]
[TD] 1[/TD]
[TD]26B961351[/TD]
[TD] [/TD]
[TD]28/03/2023[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]MD-638RL2600 [/TD]
[TD] 2[/TD]
[TD]26B961352[/TD]
[TD] [/TD]
[TD]28/03/2023[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]MD-638RL2600 [/TD]
[TD] 3[/TD]
[TD]26B961355[/TD]
[TD] [/TD]
[TD]28/03/2023[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]MD-638RL2600[/TD]
[TD] 4[/TD]
[TD]26B961356[/TD]
[TD] [/TD]
[TD]28/03/2023[/TD]
[TD]1[/TD]
[/TR]
</tbody>[/TABLE]
i have a data in below mention table. i want to remove column C (serial) MD-120100000015969 upto MD-14008000000025, not delete 27M888228, can it is possible excel select auto range and remove MD(No)? i am using PIVOT table but all serial are showing.
[TABLE="width: 476"]
<colgroup><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]item[/TD]
[TD]S.No[/TD]
[TD] serial [/TD]
[TD] lot[/TD]
[TD] expiry[/TD]
[TD]Qty[/TD]
[/TR]
[TR]
[TD]MD-120100000[/TD]
[TD] 1[/TD]
[TD]MD-12010000000015969[/TD]
[TD] 2018040079[/TD]
[TD] 30/04/2021[/TD]
[TD] 1[/TD]
[/TR]
[TR]
[TD]MD-120100000[/TD]
[TD] 2[/TD]
[TD]MD-12010000000015970[/TD]
[TD] 2018040079[/TD]
[TD] 30/04/2021[/TD]
[TD] 1[/TD]
[/TR]
[TR]
[TD]MD-120100000 [/TD]
[TD] 3[/TD]
[TD]MD-12010000000015971[/TD]
[TD] 2018040079[/TD]
[TD] 30/04/2021 [/TD]
[TD] 1[/TD]
[/TR]
[TR]
[TD]MD-120100000[/TD]
[TD] 4[/TD]
[TD]MD-12010000000015972[/TD]
[TD] 2018040079 [/TD]
[TD]30/04/2021 [/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]MD-120100000[/TD]
[TD] 5[/TD]
[TD]MD-12010000000015973[/TD]
[TD] 2018040079[/TD]
[TD]30/04/2021[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]MD-120100000[/TD]
[TD] 6[/TD]
[TD]MD-12010000000015974[/TD]
[TD] 2018040079[/TD]
[TD]30/04/2021[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]MD-120100000[/TD]
[TD] 7[/TD]
[TD]MD-12010000000015975[/TD]
[TD] 2018040079[/TD]
[TD]30/04/2021[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]MD-14008000[/TD]
[TD]1[/TD]
[TD]MD-1400800000000021[/TD]
[TD]2018040444[/TD]
[TD]30/04/2021[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]MD-14008000[/TD]
[TD]2[/TD]
[TD]MD-1400800000000022[/TD]
[TD]2018040444[/TD]
[TD]30/04/2021[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]MD-14008000[/TD]
[TD]3[/TD]
[TD]MD-1400800000000023[/TD]
[TD]2018040444[/TD]
[TD]30/04/2021[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]MD-14008000[/TD]
[TD]4[/TD]
[TD]MD-1400800000000024[/TD]
[TD]2018040444[/TD]
[TD]30/04/2021[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]MD-14008000[/TD]
[TD] 5[/TD]
[TD]MD-1400800000000025[/TD]
[TD]2018040444[/TD]
[TD]30/04/2021[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]MD-500DM2700[/TD]
[TD] 1[/TD]
[TD]27M888228[/TD]
[TD] [/TD]
[TD]28/02/2023[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]MD-500DM2700[/TD]
[TD] 2[/TD]
[TD]27M888658[/TD]
[TD] [/TD]
[TD]28/02/2023[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]MD-500DM2700[/TD]
[TD] 3[/TD]
[TD]27M889216[/TD]
[TD] [/TD]
[TD]28/02/2023[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]MD-500DM2700[/TD]
[TD] 4[/TD]
[TD]27M889576[/TD]
[TD] [/TD]
[TD]01/03/2023[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]MD-500DM2700[/TD]
[TD] 5[/TD]
[TD]27M889857[/TD]
[TD] [/TD]
[TD]01/03/2023[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]MD-500DM2700[/TD]
[TD] 6[/TD]
[TD]27M889890[/TD]
[TD] [/TD]
[TD]01/03/2023[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]MD-500DM2700[/TD]
[TD] 7[/TD]
[TD]27M889891[/TD]
[TD] [/TD]
[TD]01/03/2023[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]MD-585210000[/TD]
[TD] 1[/TD]
[TD]MD-58521000000000079[/TD]
[TD] 2018040195[/TD]
[TD]30/04/2021[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]MD-585210000 [/TD]
[TD] 2[/TD]
[TD]MD-58521000000000080[/TD]
[TD] 2018040195[/TD]
[TD]30/04/2021[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]MD-585210000[/TD]
[TD] 3[/TD]
[TD]MD-58521000000000081[/TD]
[TD] 2018040195[/TD]
[TD]30/04/2021[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]MD-585210000[/TD]
[TD] 4[/TD]
[TD]MD-58521000000000082[/TD]
[TD] 2018040195[/TD]
[TD]30/04/2021[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]MD-638RL2600[/TD]
[TD] 1[/TD]
[TD]26B961351[/TD]
[TD] [/TD]
[TD]28/03/2023[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]MD-638RL2600 [/TD]
[TD] 2[/TD]
[TD]26B961352[/TD]
[TD] [/TD]
[TD]28/03/2023[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]MD-638RL2600 [/TD]
[TD] 3[/TD]
[TD]26B961355[/TD]
[TD] [/TD]
[TD]28/03/2023[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]MD-638RL2600[/TD]
[TD] 4[/TD]
[TD]26B961356[/TD]
[TD] [/TD]
[TD]28/03/2023[/TD]
[TD]1[/TD]
[/TR]
</tbody>[/TABLE]