How to make Excel calculate average for a group of values
<p>I have a data set where the number of values I have in each category in different. I want excel to automatically group values in a category and calculate the average. For example, see below:</p>

<p>Screenshot of the example data set</p>

<p><img src="https://i.stack.imgur.com/fRUNs.png" alt=""></p>

<p>As you can see X1 has three values, whereas X2 has just one value and X3 has three values. I want excel to return averages for each category as displayed in "Average" Column.</p>