Need help and assistance please! I have a sheet with 16 columns (A P) and approximately 30 rows. I have blanks throughout the sheet. I want to search for content in column A; remove blanks (rows) and copy cells (rows) with content in column A and dump in columns R AG!
I have tried the following array formulas (I started with a single column but realized I will have issues with blanks in other columns) and yes, I used shift/ctrl/enter with the arrays.
=IFERROR(INDEX($A$2:$A$50,SMALL(IF($A$2:$A$50<>"",ROW($A$2:$A$50)),ROW(C2))),"")
=IFERROR(INDEX($A$2:$A$25,SMALL(IF($A$2:$A$25<>"",ROW($A$2:$A$25)-ROW($A$2)+1,""),ROWS($A$2:A2))),"")
=IF(ROWS(F$2:F23)>COUNTA(A:A),"",INDEX(A:A,SMALL(IF(A$2:A$24<>"",ROW(A$2:A$24)),ROWS(F$2:F23))))
Need help please!
I have tried the following array formulas (I started with a single column but realized I will have issues with blanks in other columns) and yes, I used shift/ctrl/enter with the arrays.
=IFERROR(INDEX($A$2:$A$50,SMALL(IF($A$2:$A$50<>"",ROW($A$2:$A$50)),ROW(C2))),"")
=IFERROR(INDEX($A$2:$A$25,SMALL(IF($A$2:$A$25<>"",ROW($A$2:$A$25)-ROW($A$2)+1,""),ROWS($A$2:A2))),"")
=IF(ROWS(F$2:F23)>COUNTA(A:A),"",INDEX(A:A,SMALL(IF(A$2:A$24<>"",ROW(A$2:A$24)),ROWS(F$2:F23))))
Need help please!
