Office Power Query

Hi,

I am trying to use Power Query to convert a regularly used data source into a more usable format.

The data is exported as follows (/ indicates new column):

Company name / 2010 Revenue / 2011 Revenue / 2012 Revenue / 2013 Revenue / 2010 Profit / 2011 Profit / 2012 Profit / 2013 Profit / 2010 Employees / etc.

I want to unpivot this data so that it sits in the form with each company taking 4 rows(2010, 2011, 2012, 2013) and Revenue, Profit, Employees etc. each a column. If I try to unpivot this data currently I end up with way too many rows!

My current plan is to concatenate the values for each year into one colum (e.g. I will have one 2012 column containing Revenue, Profit, Employees), then unpivoting, then using delimiter to split the column back up.

Is that the best way of doing it?

Best,
Alex