Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
force to single column
Can someone here please tell me how i can force the following.....
2 rows of 3 cells each..... row 1 = A B C row 2 = 3 1 2 (but these numbers are variable) these 2 rows represent (in this case) 3 x A, 1 x B and 2 x C i want the data above to be forced into a single column in this manner A A A B C C with no blank cells inbetween if for example the numbers were A=1 B=2 C=3 then the rusult must be A B B C C C with no blank cells inbetween I hope someone can help - my EXCEL knowlege is somewhat - very - limited Regards Malcolm |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I force a pivot column if there is no data? | Excel Discussion (Misc queries) | |||
How do I force all capital in a column of lower case names? | New Users to Excel | |||
From single cell variables to a single column serie | New Users to Excel | |||
Copy column range of "single word" cells with spaces to a single c | Excel Discussion (Misc queries) | |||
Return Single Row of Numeric Data to Single Column | Excel Worksheet Functions |