How to use VBA sort 3 fields and merge first field

[shi353]

Want sort F2 F3 F4 first , merge F2 then count first item show happen counts and belongings date
Second picture show my wanted result

Can VBA do it ?Please help

Raw data below

F1	F2	F3	F4
1	Mary	M	2019/2/2
2	Wang	FM	2019/2/3
3	Mary	M	2019/2/4
4	Chang	M	2019/2/5
5	Mary	M	2019/2/6
6	Wang	FM	2019/2/7
7	Wang	FM	2019/2/8
8	Mary	FM	2019/2/9
9	Wang	FM	2019/2/10
10	Mary	FM	2019/2/11
11	Mary	FM	2019/2/12

<tbody>
</tbody>

 

[shi353]

Wanted Result! below
F1 F2 F3 F4 F5 F6 4 Chang M 2019/2/5 1 2019/2/5 8 Mary FM 2019/2/9 3 2019/2/9,2019/2/11,2019/2/12 10 FM 2019/2/11 　 　 11 FM 2019/2/12 　 　 1 Mary M 2019/2/2 3 2019/2/2,2019/2/4,2019/2/6 3 M 2019/2/4 　 　 5 M 2019/2/6 　 　 2 Wang FM 2019/2/3 4 2019/2/3,2019/2/7,2019/2/8,2019/2/10 6 FM 2019/2/7 　 　 7 FM 2019/2/8 　 　 9 FM 2019/2/10 　 　 <colgroup><col span="3"><col><col><col></colgroup><tbody> </tbody>

<colgroup><col style="mso-width-source:userset;mso-width-alt:2304; width:47pt" width="63" span="3"> <col style="mso-width-source:userset;mso-width-alt:4278;width:88pt" width="117"> <col style="mso-width-source:userset;mso-width-alt:2742;width:56pt" width="75"> <col style="mso-width-source:userset;mso-width-alt:10825;width:222pt" width="296"> </colgroup><tbody>
</tbody>