Reshaping World Bank Data
<p>Trying to run analysis on WB data (in .xlsx form), however the data is not ready for regression. Currently each row contains data on a different country, and each column is data for a specific year.</p>

<p>Ideally, I'd like to create a new sheet/data table of three columns: Country, Year and MeanValue. Each row of MeanValue would equal the mean value for each year column in the original sheet.</p>

<p>Can anyone point me in the right direction? Thanks.</p>