Splitting Cell into Multiple row using array-CodePudding

Home > Software engineering > Splitting Cell into Multiple row using array

Splitting Cell into Multiple row using array

Time：09-21

I am trying to split the range of data like this :-

At first I was using this :-

=ARRAYFORMULA(IF(ROW($B$2:$B)>=(SUM($A$2:$A) ROW()),"",IFERROR(SPLIT(LOOKUP(ROW($B$2:$B)-ROW(),IF(ROW($B$2:$B)>=(SUM($A$2:$A) ROW()),"",SUMIF(ROW($A$2:$A),"<"&ROW($A$2:$A),$A$2:$A)),A2:A),"


          
          
            Page link：https//www.codepudding.com/Softwareengineering/551827.html
          
          
               Prev:How do i count checkboxes and divide on number?
               Next:Google Sheets sum of columns by matching 3 columns with one additional criteria


  
    
      
        
          
             Tags：  
google-sheets               
        
      
    
  
 
    
      
        
        	
            	Related
            
                       
        
      
    
  

  
    
      
        
           Links：  
          CodePudding

            
      
    
  


  About Us:          Contact Us      Terms of Service      
Privacy Policy
  Copyright © 2010-2023，Powered By CodePudding