Return column to row classified by parent

Hi, im newcomer here, and glad to find this forum.

if anyone can help me, please ..!

I have table:
Product : A: B : C: D: E: F: G: H (row 1)
X : 1: 2: 3: 4: 5: 6: 7: 8 (row 2)
Y : 10: 11: 12: 13: 14: 15: 17: 23 (row3)
Region1 is parent of A&B
Region2 is parent of C&D
Region3 is parent of E&F
Region4 is parent of G&H
East is parent of Region1 & Region2
West is parent of Region3 & Region4

Table expected:
X : East : Region1 : A : 1
X : East : Region1 : B : 2
X : East : Region2 : C : 3
X : East : Region2 : D : 4
X : West : Region3 : E : 5
X : West : Region3 : F : 6
X : West : Region4 : G : 7
X : West : Region4 : H : 8
Y : East : Region1 : A : 10
Y : East : Region1 : B : 11
Y : East : Region2 : C : 12
Y : East : Region2 : D : 13
Y : West : Region3 : E : 14
Y : West : Region3 : F : 15
Y : West : Region4 : G : 23
Y : West : Region4 : H : 17

Thank you verymuch for any replies

Cheers

Hello Dorian,

Can you be more specific about what your problem is, i.e. (What isn't the program doing), where the data is located (Worksheet names, Cells), and the results you expect. Please aviod using jargon in your posts. If you will do this then I can help you.

Thanks,
Leith Ross

Please see my attachment.
Crosstab.xls consist only 1 worksheet (crosstab), if that what u mean.
In that file, i explained what table i have, and what table i want to develop from my current table.

If its not clear enogh for u, can u give me ur email address, so then i can send u my table.

Thanks