Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
MERGING COLUMNS TO ONE
Would one of you experts kindly devise me a code so as to merge the different
sizes of blocks of a table in a single column. For example the source data is A01 BX1 C2 D1 A02 BX2 D2 A03 BX3 A04 D3 What code could copy the columns onto some other location/sheet as follows: A01 A02 A03 A04 BX1 BX2 BX3 C2 D1 D2 <<Blank Cell D3 cpearson's outstanding the reversal, i.e. Column to Table at http://www.cpearson.com/Excel/Variab...mnToTable.aspx but I sure am making mistakes in having the said code modified to carry out such exercise the other way around. Thanx in advance. -- Best Regards, Faraz |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merging Columns | Excel Worksheet Functions | |||
Merging 2 columns | Excel Discussion (Misc queries) | |||
merging columns | New Users to Excel | |||
Merging columns | New Users to Excel | |||
Merging Columns | Excel Worksheet Functions |