How to transform table for calculating average and errors

[nufffins]

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.

[v-easonf-msft · Accepted solution]

Hi, @nufffins 

You need to split the original table into the following two tables and append them again.

Best Regards,
Community Support Team _ Eason

[nufffins]

Thanks, it works!