| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Repeat data
How do I repeat the stuff in column A when there's stuff in Col B?
My spreadsheet looks like this: A B 000771605-0 1976 0000000 000771607-2 1976 0000000 0284831 000800014-5 2009 0000000 0681378 0681864 0682617 000804444-2 1981 0000000 0284831 000804444-2 1983 0000000 0284831 000804448-6 1980 0000000 000804448-6 1982 0000000 0681804 000812407-4 2006 0000000 0681865 0682683 0682694 0682695 0682697 0684836 000812415-1 2003 0000000 0681865 0682683 0682694 0682695 0682697 0684836 ====================================== Here's what I need: A B 000771605-0 1976 0000000 000771607-2 1976 0000000 000771607-2 1976 0284831 000800014-5 2009 0000000 000800014-5 2009 0681378 000800014-5 2009 0681864 000800014-5 2009 0682617 000804444-2 1981 0000000 000804444-2 1981 0284831 000804444-2 1983 0000000 000804444-2 1983 0284831 000804448-6 1980 0000000 000804448-6 1982 0000000 000804448-6 1982 0681804 000812407-4 2006 0000000 000812407-4 2006 0681865 000812407-4 2006 0682683 000812407-4 2006 0682694 000812407-4 2006 0682695 000812407-4 2006 0682697 000812407-4 2006 0684836 000812415-1 2003 0000000 000812415-1 2003 0681865 000812415-1 2003 0682683 000812415-1 2003 0682694 000812415-1 2003 0682695 000812415-1 2003 0682697 000812415-1 2003 0684836 Thank you in advance, GaryWC |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Repeat row data | Excel Discussion (Misc queries) | |||
| Repeat data | Excel Discussion (Misc queries) | |||
| To repeat data row after row. | Excel Programming | |||
| Title Cut Off if Rows to Repeat & Columns to Repeat are Both Selec | Excel Discussion (Misc queries) | |||
| Repeat Data | Excel Programming | |||
Threaded Mode
