Comparing data table header column

[ppr (Peter Preuss)]

@Shanika_Perera
Variables:

we assume that read range with AddHeaders ticked OFF (along with the demerged cells) will create a datatable with auto generated header names similar like this:

Helpers:
we defined an array with col indexes not to use for the checks: arrBlockIDX variable

and we create some helper (used later)

we create an Info on the columns for check without the blocked cols:

we calculate the duplicates and non duplicates:

then we prepare String Arrays for the both cases later use for the datatble col filters / removal

And remove/filter to the datatables

Find starter help here:
DuplicatedColInfo_SplitUnique-Dup.V2.xaml (13.6 KB)

And some introduction to LINQ here:
[HowTo] LINQ (VB.Net) Learning Catalogue - Help / Something Else - UiPath Community Forum