| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Table Transform
I have a table which is 6 rows by 4 columns & I would like to transform
this into 24 rows by 1 column. That is, copy the contents of column 2, 3 & 4 to the bottom of column 1. How can I do this? Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Table Transform
I meant programmatically since the transpose function does not work in
this case. James wrote: I have a table which is 6 rows by 4 columns & I would like to transform this into 24 rows by 1 column. That is, copy the contents of column 2, 3 & 4 to the bottom of column 1. How can I do this? Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Table Transform
If your table is in A1:D6, then in A7 put the formula
=OFFSET(A$1,MOD((ROW()-1),6),INT((ROW()-1)/6)) and copy down to A24. -- David Biddulph "James" wrote in message ps.com... I have a table which is 6 rows by 4 columns & I would like to transform this into 24 rows by 1 column. That is, copy the contents of column 2, 3 & 4 to the bottom of column 1. How can I do this? Thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Table Transform
It works! thanks
David Biddulph wrote: If your table is in A1:D6, then in A7 put the formula =OFFSET(A$1,MOD((ROW()-1),6),INT((ROW()-1)/6)) and copy down to A24. -- David Biddulph "James" wrote in message ps.com... I have a table which is 6 rows by 4 columns & I would like to transform this into 24 rows by 1 column. That is, copy the contents of column 2, 3 & 4 to the bottom of column 1. How can I do this? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create a Word Table from a Excel Macro | Excel Discussion (Misc queries) | |||
| How do I link a cell outside a pivot table to one inside the table | Excel Discussion (Misc queries) | |||
| Custom field in Pivot Table? | Excel Discussion (Misc queries) | |||
| Pivot Table external XLS file source change and GETPIVOTDATA refresh | Excel Discussion (Misc queries) | |||
| Change Data In Pivot Table | New Users to Excel | |||
Linear Mode
