Merge cell with dublicate entry in one and count no of same elements in last column

hello freinds.
i want to merge column of datatable basis of their name and id and also to count the no of skills column yes for individual person and there are multiple column in the real task also so no change in format except these. i think this can be achieve with linq but i dont know how to do it. please its so urgent. here is the example excel fileforum.xlsx (17.6 KB)

did we try with VB Code like using Macro and we can call with INVOKE VBA or EXECUTE MACRO
Cheers @amit_joshi

actually i want do it with linq querry however i wanna check it vb code also can you explain me how i can do it.