Remove duplicates in specific range

Hi all,
I have a table as shown below (attached file)
Screenshot 2024-10-08 073939.png
I would like to remove duplicates from A5 to , specifically in the "Index" column. However, if I use the "Remove Duplicates" function in the Table Design tab, it removes duplicates from the entire table, which is not what I want.

Could you please advise on how to remove duplicates only from that specific range?

Thank you in advance!

There are instructions at the top of the page explaining how to attach your sample workbook (yellow banner: HOW TO ATTACH YOUR SAMPLE WORKBOOK). Screenshots are of little practical use as we cannot manipulate them.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. The sample layout accurately matches that of your real data. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

With Power Query
1.Load your table to the PQ Editor
2.Duplicate your table
3.In the Duplicate table, enact this Mcode

let
    Source = Excel.CurrentWorkbook(){[Name="Table2"]}[Content],
    #"Removed Duplicates" = Table.Distinct(Source, {"Index"})
in
    #"Removed Duplicates"

4. Perform a full outer join on the original table and the duplicate table.

let
    Source = Table.NestedJoin(Table2, {"Index", "Value"}, #"Table2 (2)", {"Index", "Value"}, "Table2 (2)", JoinKind.FullOuter),
    #"Expanded Table2 (2)" = Table.ExpandTableColumn(Source, "Table2 (2)", {"Index"}, {"Index.1"}),
    #"Removed Columns" = Table.RemoveColumns(#"Expanded Table2 (2)",{"Index"}),
    #"Reordered Columns" = Table.ReorderColumns(#"Removed Columns",{"Index.1", "Value"}),
    #"Renamed Columns" = Table.RenameColumns(#"Reordered Columns",{{"Index.1", "Index"}})
in
    #"Renamed Columns"

Excel 2016 (Windows) 64 bit

	A	B	C	D	E
1	Index	Value		Index	Value
2	0001	2		0001	2
3	0002	3		0002	3
4	0001	7			7
5	0002	10			10
6	0003	11		0003	11
7	0002	10			10

Sheet: Sheet2