transpose without 0's and blanks

  • Thread starter Thread starter ali
  • Start date Start date
A

ali

Hi guys,

I have data in row with certain cells blank and certain cells have 0
value. I want to transpose row into column but only want non-blank and
non zero cells. Like if data is:

1 blank 2 0 3

it should become

1
2
3

Any suggestions please. Would be grateful

Thanks

ali
 
Did you try the solution I gave you 9 hours prior to your posting here to
this identical question?

Rick
 
Back
Top