Forum Discussion
Excel Summary
How can I display data on a new sheet without the gaps in the data going across. I want to eliminate the columns with no data so it can be read easily. TY
=IFERROR(INDEX(2:2,SMALL(IF(2:2<>"",COLUMN($1:$1048576)),COLUMN(A:A))),"")You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021. The formula is in cell B8 and filled across range B8:I10.