It is unclear what you mean with "aligned", but the following structure could probably help you. Note that the dime difference is calculated in the last step, and this you can use for your definition of "aligned".
SourceData: Load ID, Project, Timepoint, Date#(Date,'M/D/YYYY') as Date Inline [ID,Project,Timepoint,Date 1,P1,T1,1/1/2022 1,P1,T2,2/1/2022 2,P2,T1,5/1/2023 1,p3,T1,1/1/2022 1,p3,T2,2/15/2022 1,p3,T3,3/1/2022];
FlattenedTable1: Load distinct ID, Project Resident SourceData; Left Join (FlattenedTable1) Load ID, Project, Date as T1 Resident SourceData Where Timepoint='T1'; Left Join (FlattenedTable1) Load ID, Project, Date as T2 Resident SourceData Where Timepoint='T2'; Left Join (FlattenedTable1) Load ID, Project, Date as T3 Resident SourceData Where Timepoint='T3';
Drop Table SourceData;
FlattenedTable2: Load T2-T1 as Diff_T1_T2, T3-T1 as Diff_T1_T3, * Resident FlattenedTable1;