Index,Match,CountIF Formula NOT working for removing duplicate rows frm Table- plz, Check?

Request#1:
I want to segregate duplicates rows and was using Index, Match and CountIF formulas (please see below) but not sure this isn't working for me. Other than this was searching in internet and used different other Formulas but even those aren't working. Can you please someone please check and correct and let me know what's wrong I'm doing
=INDEX($G$22:$G$26, MATCH(0, COUNTIF($G$66:G66, $G$22:$G$26), 0)) [/LEFT]

Screenshot 1.PNG

Ones if above is possible/done ---- the corresponding cells in the table should be added.
For example: Say, I have John 4 times in Table-2, in Table-3 he should appear once and columns related to John in Table-2 should be added in Table-3

Request#2
"Table 4 values are dependent on Row 81 and Table 3.
If checked (Row 81); sprint 7.1 value is 7 and sprint 7.3 value is 8
If you see Table 4 and Resource Chritina or Sherry … they don't appear in Table 3 … so there values remain same as Row 81 values
Since John/Jerry/Pat ... appreas in Table 3 .... their corresponding values is equal to Sprint Capacity - Value in Table 3
For John, for Sprint 7.1, value in table 4 is equal to 7 minus 3 = 4 (H81 - H73)"

I request to please take a look at the attached spreadsheet for more details and also to have clear idea about my requests

Screenshot 2.PNG