Multiple Cross Table

[#1]

Hi!

I need something like doing a cross table twice.

I have an excel table that looks like this:

Qualifier1, Qualifier2, DataA_Period1, DataA_Period2, DataA_Period3, DataB_Period1, DataB_Period2, DataB_Period3

and I need it like this:

Qualifier1, Qualifier2, Type, Period, Data
... , ... , A, Period1, <data>
... , ... , A, Period2, <data>
... , ... , A, Period3, <data>
... , ... , B, Period1, <data>
... , ... , B, Period2, <data>
... , ... , B, Period3, <data>
.....

any ideas?

thanks in advance.