| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Rows to columns in a table or pivot table | Excel Discussion (Misc queries) | |||
| Too many rows or columns in pivot table | Excel Discussion (Misc queries) | |||
| Too many rows or columns in my pivot-table | Excel Discussion (Misc queries) | |||
| how to interchange rows to columns & columns to rows in a table | Excel Discussion (Misc queries) | |||
| Change data to appear in rows instead of columns (reverse a table. | Excel Discussion (Misc queries) | |||
Threaded Mode
