Construct a list that excludes 0 (from 0 0 0 1 2 3 to 1 2 3)

[franlem2]

Hi

I am trying to do a thing automatically. It's part of a more global automatization.

I have a range with the values 0 0 0 0 1 2 3 0 0 0 and I want, on the right, to get the list of 1 2 3 appearing.

Please look at the picture for an example of what I would need to do. Do you have any idea about how to do it ? A replace is not a solution for me as it's part of numerous steps to automatize a file. It must appear exactly as in the example. Thanks to those who will help me.

Best regards.

 

[mikerickson]

If 0, 0, 0, 0, 0, D009 is in B4:G4

Then select I4:N4,
type =IFERROR(INDEX($A4:$G4,SMALL(IF($B4:$G4<>0,COLUMN($B4:$G4)),COLUMN($A4:$G4))),"") into the formula bar
and enter it with Ctrl-Shift-Enter

Then drag down.

 

[franlem2]

It works perfectly Mikerickson, thanks a lot for your help !!