transpose without 0's and blanks
 

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

transpose without 0's and blanks
 

Didn't any of the suggestions at your other posts work?

ali wrote:

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

--

Dave Peterson

transpose without 0's and blanks
 

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

Rick


"ali" wrote in message
oups.com...
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