transpose skip 0's and blanks

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
 
R

Rick Rothstein \(MVP - VB\)

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

Rick
 
A

ali

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

Rick









- Show quoted text -
Click to expand...

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Eliminate blanks while copy row and transpose 11
Skip copying empty column where remaining rows are filled 2
Return BLANK is cell value sought is blank 13
transpose without 0's and blanks 1
Ignoring a blank cell while running a macro. 1
Concat a three column range into one cell Then Next... 2
Remove Identical words 0
Copy named range, but skip blanks 1

Top