Rows of Data to Column Subgroups

[hot6l]

Hi there,

Just wondering if there's an easy way to turn a table of data formatted like this:


Country, 1960, 1961, 1962, 1963
Angola:, 10, 12, 14, 16
Benin:, 20, 14, 12, 31
...

Into this:

Angola, 1960, 10
Angola, 1961, 12
Angola, 1962, 14
Angola, 1963, 16
Benin, 1960, 20
Benin, 1961, 14
Benin, 1962, 12
Benin, 1963, 31
...

I'm using excel on a mac, so I guess VBA isn't really an option.

Thanks!

 

[hot6l]

Nevermind.

The answer is here:

http://www.excelforum.com/excel-general/721812-column-headers-to-column-data.html

Hi there,

Just wondering if there's an easy way to turn a table of data formatted like this:


Country, 1960, 1961, 1962, 1963
Angola:, 10, 12, 14, 16
Benin:, 20, 14, 12, 31
...

Into this:

Angola, 1960, 10
Angola, 1961, 12
Angola, 1962, 14
Angola, 1963, 16
Benin, 1960, 20
Benin, 1961, 14
Benin, 1962, 12
Benin, 1963, 31
...

I'm using excel on a mac, so I guess VBA isn't really an option.

Thanks!