How to reshape data from WIDE to LONG format in Excel?
Posted on 2010-10-17
in Excel (2010), who knows the smartest way to reshape a dataset of GDP values in WIDE format, e.g.
country1 | country2 | country3 ....
to LONG format, e.g.
date1 country1 GDP11
date2 country1 GDP21
date1 country2 GDP12
date2 country2 GDP22
(order of rows doesn't matter) ?
I know some statistics programs like Stata do this with the reshape command, and you can obviously also stack the columns of the wide version so as to produce a long table in VBA, but I'd like to see if you can do this in plain Excel. If this is not possible with on-board excel commands, a generic VBA-script or Add-in being able to do this without much customization would be considered a second-best solution.
The long table will afterwards be loaded into a MySQL database table.