Convert, transform or transpose LO Calc table from wide to long format

[singularity]

Hello All,

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?
Thanks

The real table example is below

real table.ods

[JohnSUN]

Try this extention - decroise

[singularity]

Спасибо земляк Exactly what I was looking for.
Work for me.

[mikekaganski]

Cut->Paste Special->Transpose

[singularity]

Transpose only works in proper way when you have simple table. May be I miss specify what I exactly need. I have approx. 30 tables 32 rows x 9 columns each. And simple transpose did not work
Thanks