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

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - change a table to 3 columns only (Rows instead of Table) (https://www.excelbanter.com/excel-programming/306323-change-table-3-columns-only-rows-instead-table.html)

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

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

and again: please don't multipost

--
Regards
Frank Kabel
Frankfurt, Germany

Mo wrote:
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