rhockmanBrass ContributorFeb 16, 2023Excel 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 Show More
LorenzoSilver ContributorMay 12, 2023rhockman Alternatively if you run 2021 or 365=FILTER(B3:J5, MMULT(SEQUENCE(,ROWS(B3:J5)),--(B3:J5<>"")))
