Hi all,

my dataset looks as follows

Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input str83 IndicationLevel3 str72 Company str88 Product
"COVID-19 treatment"                            "SAB Biotherapeutics"         "SAB-185"                                          
"Arthritis, general"                            "Rus BioPharm"                "Adalimumab"                                       
"Arthritis, general"                            ""                            ""                                                 
"Leukaemia, acute myeloid (AML)"                "CoImmune"                    "CIK-CAR.CD33"                                     
"General cancer indications"                    "iTeos Therapeutics"          "EOS884448"                                        
"Hepatoma, liver cancer"                        "CrystalGenomics"             "AiRuiKa"                                          
"Oesophageal cancer"                            ""                            ""                                                 
"Non-small cell lung cancer (NSCLC)"            ""                            ""                                                 
"COVID-19 treatment"                            ""                            ""                                                 
"Glioblastoma multiforme"                       ""                            ""                                                 
"Solid tumour indications"                      ""                            ""                                                 
"Gastro-intestinal adenocarcinoma"              ""                            ""                                                 
"Head & neck cancers"                           ""                            ""                                                 
"Stomach cancer"                                ""                            ""                                                 
"Ovarian cancer"                                ""                            ""                                                 
"Bone cancer (Osteosarcoma)"                    ""                            ""                                                 
"Melanoma"                                      ""                            ""                                                 
"Hodgkin lymphoma"                              ""                            ""                                                 
"Cervical cancer"                               ""                            ""                                                 
"Renal cell carcinoma (RCC)"                    ""                            ""                                                 
"Bladder cancer"                                ""                            ""                                                 
"Soft tissue sarcoma"                           ""                            ""                                                 
"Breast cancer"                                 ""                            ""                                                 
"Brain metastases"                              ""                            ""                                                 
"Uterine cancer"                                ""                            ""                                                 
"Pancreatic cancer"                             ""                            ""                                                 
"Arthritis, juvenile idiopathic (JIA)"          "GeneScience Pharmaceuticals" "Genakumab"                                        
"Peripheral vascular disease (PVD)"             "Vericel"                     "Ixmyelocel-T"                                     
"Bone repair & regeneration"                    ""                            ""                                                 
"Dilated cardiomyopathy"                        ""                            ""                                                 
"Avascular necrosis"                            ""                            ""                                                 
"Pulmonary fibrosis, idiopathic"                ""                            ""                                                 
"Atherosclerosis"                               ""                            ""                                                 
"Spinal cord injury"                            "Vericel"                     "Neural Repair Cells"                              
"Chemotherapy-induced side effects"             "Vericel"                     "Blood System Restoration"                         
"Melanoma"                                      "Vericel"                     "Anti-Cancer T Cells"                              
"Bone repair & regeneration"                    "Vericel"                     "Carticel"                                         
"Burns"                                         "Vericel"                     "Epicel"                                           
"Bone repair & regeneration"                    "Vericel"                     "MACI"                                             
"Relapsing-Remitting MS (RRMS)"                 "Acorda Therapeutics"         "rHIgM22"                                          
"Stroke, acute"                                 ""                            ""                                                 
"Traumatic brain injury"                        ""                            ""                                                 
"Sclerosing cholangitis"                        "Acorda Therapeutics"         "BTT1023"                                          
"COAD/COPD"                                     ""                            ""                                                 
"Asthma"                                        ""                            ""                                                 
"Inflammatory bowel disease (IBD), unspecified" ""                            ""                                                 
"Other neurological indications"                ""                            ""                                                 
"Psoriasis"                                     ""                            ""                                                 
"Myocardial infarction, acute (AMI)"            ""                            ""                                                 
"Crohn's disease"                               ""                            ""                                                 
"Arthritis, rheumatoid"                         ""                            ""                                                 
"Ulcerative colitis"                            ""                            ""                                                 
"Organ rejection"                               ""                            ""                                                 
"Inflammatory skin disorders"                   ""                            ""                                                 
"Respiratory distress syndrome (RDS)"           ""                            ""                                                 
"General cancer indications"                    "Ocata Therapeutics"          "Hemangioblast Cell Program"                       
"Diabetic retinopathy"                          ""                            ""                                                 
"Myocardial infarction, acute (AMI)"            ""                            ""                                                 
"Peripheral vascular disease (PVD)"             ""                            ""                                                 
"Chronic heart failure (CHF)"                   ""                            ""                                                 
"Stroke, acute"                                 ""                            ""                                                 
"General cardiovascular indications"            ""                            ""                                                 
"Chronic heart failure (CHF)"                   "Ocata Therapeutics"          "Myoblast Program"                                 
"General eye disorders"                         "Ocata Therapeutics"          "ASP7317"                                          
"Dry age-related macular degeneration (AMD)"    ""                            ""                                                 
"Retinitis pigmentosa"                          ""                            ""                                                 
"General liver disorders"                       "Ocata Therapeutics"          "CytoHep"                                          
"Crigler-Najjar syndrome"                       ""                            ""                                                 
"Parkinson's disease"                           "Ocata Therapeutics"          "ISC-hpNSC"                                        
"Stroke, acute"                                 ""                            ""                                                 
"Traumatic brain injury"                        ""                            ""                                                 
"Organ rejection"                               "Ocata Therapeutics"          "CytoCor"                                          
"General eye disorders"                         ""                            ""                                                 
"Dry age-related macular degeneration (AMD)"    "Ocata Therapeutics"          "CytoRet"                                          
"Retinitis pigmentosa"                          ""                            ""                                                 
"Diabetes, type 1"                              "Ocata Therapeutics"          "Diabetes Stem Cell Research Project (ISCO)"       
"General eye disorders"                         "Ocata Therapeutics"          "Ocular Program (YAM)"                             
"Glaucoma"                                      ""                            ""                                                 
"Skin wounds"                                   "Ocata Therapeutics"          "MSC Program"                                      
"Other ear disorders"                           ""                            ""                                                 
"Retinitis pigmentosa"                          ""                            ""                                                 
"Glaucoma"                                      ""                            ""                                                 
"Other immune indications"                      ""                            ""                                                 
"General inflammatory disorders"                ""                            ""                                                 
"Uveitis"                                       ""                            ""                                                 
"Dry age-related macular degeneration (AMD)"    "Ocata Therapeutics"          "Transplantable Photoreceptor Progenitors"         
"Glaucoma"                                      "Ocata Therapeutics"          "Ganglion Nerve Progenitors"                       
"General eye disorders"                         "Ocata Therapeutics"          "DSEK Corneal Transplant Tissue"                   
"General haematological indications"            "Ocata Therapeutics"          "ACT Platelet Program"                             
"Systemic lupus erythematosus (SLE)"            "Ocata Therapeutics"          "hESC-MSC"                                         
"Uveitis"                                       ""                            ""                                                 
"Multiple sclerosis (MS) unspecified"           ""                            ""                                                 
"Pain, general"                                 ""                            ""                                                 
"Alzheimer's disease"                           "Ocata Therapeutics"          "Alzheimers Disease Research Program (YAM)"        
"Inflammatory bowel disease (IBD), unspecified" "Ocata Therapeutics"          "Inflammatory Bowel Disease Research Program (YAM)"
"Sepsis/Septic shock"                           "Ocata Therapeutics"          "Sepsis Research Project (YAM)"                    
"Anaemia, haemolytic"                           "Ocata Therapeutics"          "RBC Program"                                      
"Skin wounds"                                   ""                            ""                                                 
"Haemophilia, general"                          "Ocata Therapeutics"          "2nd Generation Platelet Product"                  
"Ulcers, diabetic foot"                         ""                            ""                                                 
end
I would like to replace the blanks with the data (Product and Company) of the first product before the blanks in Company and Product. So, for instance, in the present case, the first blank should be replaced by "Rus BioPharm" "Adalimumab", the 21 blanks after "CrystalGenomics" "AiRuiKa" should be replaced with "CrystalGenomics" "AiRuiKa" until "GeneScience Pharmaceuticals" "Genakumab" and so on.

Is it possible to do so?

Thank you