change a table to 3 columns only (Rows instead of Table)

[Mo]

Hi,

I am looking forward to your inputs, I have a table, here
is a sample:

Dept1 Dept2 Dept3 Dept4
Div1 1 2 3 4
Div2 5 6 7 8
Div3 9 10 11 12

How can I change the above table to 3 columns only (Rows
instead of Table):

Div1 Dept1 1
Div1 Dept2 2
Div1 Dept3 3
Div1 Dept4 4
Div2 Dept1 5
Div2 Dept2 6
Div2 Dept3 7
Div2 Dept4 8
Div3 Dept1 9
Div3 Dept2 10
Div3 Dept3 11
Div3 Dept4 12

The table I have is huge, doing the above manually will be
very time consuming.

Thanks
Mo

 

[Frank Kabel]

Hi
see your other posts