Thread: Repeat data
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
gary gary is offline
external usenet poster
 
Posts: 80
Default 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