How to transform table for calculating average and errors

Hello!

I am learning to use Power BI and ran into problem with this data. My data is similar to the yellow table - different numbers of columns with same name - and I want to transform it to blue table - to calculate average for the sampls with same name for each timepoint - as easily as possible.