Deleting zero values and their corresponding column

[limpfisch]

Hi

Can someone please explain a way for me to go from the input in columns A and B to the output in columns E and F

Thank you.

[azumi]

Put this on E1 and copied down

=IFERROR(VLOOKUP(F1,CHOOSE({1\2},$B$1:$B$9,$A$1:$A$9),2,0),"")

And put this on F1 and copied down

=IFERROR(INDEX($B$1:$B$9,AGGREGATE(15,6,(ROW($B$1:$B$9)-MIN(ROW($B$1:$B$9))+1)/($B$1:$B$9<>0),ROW(A1))),"")

Hope this works

[FlameRetired]

Another way ... similar ... does both columns. In E1 fill down and across column F.

=IFERROR(INDEX(A$1:A$9,AGGREGATE(15,6,(ROW($A$1:$A$9)-MIN(ROW($A$1:$A$9))+1)/($B$1:$B$9<>0),ROWS($A$1:$A1))),"")