Pivoting columns with start and end date

Hi all,   I am stuck with Pivoting columns in Power Query, Powerbi.   I have table 1 and want to create table 2 and table 3 (see example data below).   If a contact has a one year membership (e...