I think its a very trivial question, and may be was asked many times before. I have seen some commercial extensions for MS Office Excel which can do that, but I do not have Windows PC. I am using Linux.
Is there any way (tool, add-on, script, macro, life-hack, feature) to convert, transform or transpose LO Calc table from wide to long format. See example:
I have a lot tables in wide format:
2008 2009 2010 2011 EU 1 2 3 4 US a b c d UK w x y z
And for further processing I need to have all of them in long format:
EU 2008 1 EU 2009 2 EU 2010 3 EU 2011 4 US 2008 a US 2009 b US 2010 c US 2011 d ....................
Are there some automatic tools to do that?
The real table example is below