Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to merge many columns to one columnn
I have many cols, same length and containing numeric data. I want to merge
them into one col. The merge should stack all of colB under colA, colC under colB and so on. Origainal data is: A B C D ........ 1 2 3 4 ........ . . . . ........ . . . . ........ After merge A 1 .. .. 2 .. .. 3 .. .. 1 2 3 4 1920 1.1 2.2 3.3 4.3 ............................................... 5.7 1921 4.2 3.1 5.6 6.9 ................................................ 6.8 1922 5.3 6.2 1.9 2.6 ............................................... ...... .... .... .... .... ............................................... 2007 3.2 5.1 2.7 6.5 ................................5.9 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
merge columns | New Users to Excel | |||
merge columns | Excel Worksheet Functions | |||
merge text from 2 columns into 1 then delete the old 2 columns | Excel Worksheet Functions | |||
I want to merge two columns | New Users to Excel | |||
How to merge columns | Excel Worksheet Functions |