Transpose data with same value to one row

Hello, I have been cracking my head for two days but can’t seems to figure out a way to do this in Excel and I would like to see if anyone from the community could help.

I have a data (sheet name Data) and I would like to know if it’s possible to run a macro to convert it to the format as shown in (sheet name Macro-ed Result)

Each family has one unique Family No and I would like all information about a Family to be in one row so that it become like one record as shown in the Sheet name Macro-ed Result.

The macro should also remove duplicated email addresses automatically.

Attached is the excel spreadsheet and I would really appreciate it if you could help me on this.

Thanks in advance
Aznan Nagor
The International School of Penang (Uplands)