View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mo[_7_] Mo[_7_] is offline
external usenet poster
 
Posts: 1
Default change a table to 3 columns only (Rows instead of Table)

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