transpose skip 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 skip 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 skip 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

transpose skip 0's and blanks
 

On Jul 19, 3:29 am, "Rick Rothstein \(MVP - VB\)"
wrote:
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- Hide quoted text -

- Show quoted text -

hi guys
thanks. It was due to some google delay that the posts didnt appear to
me to have been posted. Thanks for the code Rick. Problem sorted.

ali