I got more than 1000 columns. Hence, removing duplicates in each column is time consuming. Could anyone suggests a VBA code that can solve this problem? Thanks in advance.
Raw Data
[TABLE="width: 256"]
<tbody>[TR]
[TD="width: 64"]Header1[/TD]
[TD="width: 64"]Header2[/TD]
[TD="width: 64"]Header3[/TD]
[TD="width: 64"]Header4[/TD]
[/TR]
[TR]
[TD="align: right"]48251[/TD]
[TD="align: right"]41253[/TD]
[TD="align: right"]474565[/TD]
[TD="align: right"]456[/TD]
[/TR]
[TR]
[TD="align: right"]48251[/TD]
[TD="align: right"]2178965[/TD]
[TD="align: right"]474565[/TD]
[TD="align: right"]45612[/TD]
[/TR]
[TR]
[TD="align: right"]48251[/TD]
[TD="align: right"]1235[/TD]
[TD="align: right"]45[/TD]
[TD="align: right"]456[/TD]
[/TR]
[TR]
[TD="align: right"]45621[/TD]
[TD="align: right"]1235[/TD]
[TD="align: right"]45[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]4123[/TD]
[TD="align: right"]415[/TD]
[TD="align: right"]45[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]4123[/TD]
[TD][/TD]
[TD="align: right"]123[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]4123[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]4123[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Expected outcome
[TABLE="width: 256"]
<tbody>[TR]
[TD="width: 64"]Header1[/TD]
[TD="width: 64"]Header2[/TD]
[TD="width: 64"]Header3[/TD]
[TD="width: 64"]Header4[/TD]
[/TR]
[TR]
[TD="align: right"]48251[/TD]
[TD="align: right"]41253[/TD]
[TD="align: right"]474565[/TD]
[TD="align: right"]456[/TD]
[/TR]
[TR]
[TD="align: right"]45621[/TD]
[TD="align: right"]2178965[/TD]
[TD="align: right"]45[/TD]
[TD="align: right"]45612[/TD]
[/TR]
[TR]
[TD="align: right"]4123[/TD]
[TD="align: right"]1235[/TD]
[TD="align: right"]123[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]415[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Raw Data
[TABLE="width: 256"]
<tbody>[TR]
[TD="width: 64"]Header1[/TD]
[TD="width: 64"]Header2[/TD]
[TD="width: 64"]Header3[/TD]
[TD="width: 64"]Header4[/TD]
[/TR]
[TR]
[TD="align: right"]48251[/TD]
[TD="align: right"]41253[/TD]
[TD="align: right"]474565[/TD]
[TD="align: right"]456[/TD]
[/TR]
[TR]
[TD="align: right"]48251[/TD]
[TD="align: right"]2178965[/TD]
[TD="align: right"]474565[/TD]
[TD="align: right"]45612[/TD]
[/TR]
[TR]
[TD="align: right"]48251[/TD]
[TD="align: right"]1235[/TD]
[TD="align: right"]45[/TD]
[TD="align: right"]456[/TD]
[/TR]
[TR]
[TD="align: right"]45621[/TD]
[TD="align: right"]1235[/TD]
[TD="align: right"]45[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]4123[/TD]
[TD="align: right"]415[/TD]
[TD="align: right"]45[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]4123[/TD]
[TD][/TD]
[TD="align: right"]123[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]4123[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]4123[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Expected outcome
[TABLE="width: 256"]
<tbody>[TR]
[TD="width: 64"]Header1[/TD]
[TD="width: 64"]Header2[/TD]
[TD="width: 64"]Header3[/TD]
[TD="width: 64"]Header4[/TD]
[/TR]
[TR]
[TD="align: right"]48251[/TD]
[TD="align: right"]41253[/TD]
[TD="align: right"]474565[/TD]
[TD="align: right"]456[/TD]
[/TR]
[TR]
[TD="align: right"]45621[/TD]
[TD="align: right"]2178965[/TD]
[TD="align: right"]45[/TD]
[TD="align: right"]45612[/TD]
[/TR]
[TR]
[TD="align: right"]4123[/TD]
[TD="align: right"]1235[/TD]
[TD="align: right"]123[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]415[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]