Is there any way to find average in excel file for a particular sample

I have large excel file of such sample data as given below, randomly placed:

I want average for each sample. Please help how to do it. To get the average in one go without doing it manually for each sample.

There are at least 500 samples so applying formula may help.

>Solution :

Put headers above the list, then insert a Pivottable with the sample as Row header and the average value as Data element.