Urgent method required to achieve the desired goal in pivot table using following data

[Achyuth]

Below is my data which I am able to achieve using this formula.
=SUBSTITUTE(TRIM(SUBSTITUTE(CONCAT(IF(MID(","&A2&",",ROW(INDIRECT("1:"&LEN(A2)+1)),1)=",",IF(ISERROR(SEARCH(MID(","&A2&",",ROW(INDIRECT("1:"&LEN(A2)+1)),FIND(",",","&A2&",",ROW(INDIRECT("2:"&LEN(A2)+2)))-ROW(INDIRECT("1:"&LEN(A2)+1))+1),","&B2&",")),MID(","&A2&",",ROW(INDIRECT("1:"&LEN(A2)+1)),FIND(",",","&A2&",",ROW(INDIRECT("2:"&LEN(A2)+2)))-ROW(INDIRECT("1:"&LEN(A2)+1))+1),""),"")),","," "))," ",",")

on column C.

Now my question is how do I check for occurrence of top 50% of numbers under column C for each person on column D.

Data 1	Data 2	Output	Name
1, 2, 3, 4, 5	1, 2	3,4,5	Person 1
1, 3, 4	6, 7	1,3,4	Person 2
1, 3, 4, 5, 8	5, 10	1,3,4,5,8	Person 3
2, 5, 6, 7	1,3,4,6,8	2,5,6,7	Person 4
6, 8, 9, 0	6, 9, 0	8	Person 1
1, 4, 5, 6, 7, 0	1, 3, 5, 6	4,7,0	Person 2
3, 5, 7, 9	5, 7, 9	3,5	Person 3
2, 6, 8, 0	2, 5	6,8,0	Person 4
1, 4, 5, 7, 2	4, 7, 2	1,4,5	Person 1
9, 7, 5, 4, 1	9, 7, 1	5,4	Person 2
3, 4, 5, 6, 7	3, 6, 7	4,5	Person 3
3, 6, 8, 0, 1	3, 0, 1	6,8	Person 4
1, 4, 5	1, 4	5	Person 1
1, 2	2	1,2	Person 2
5, 6, 7	6, 7	5,6	Person 3
4, 8, 0	8, 0	4,8	Person 4

Desired output using pivot

Person 1	4,5
Person 2	4,1
Person 3	5, 3,4
Person 4	8, 6

Can I use calculate field to achieve this, if yes what formula should i be using, since it contains both number and text or combination of both.

Thanks for all the help earlier.