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

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

Mail Merge Switch - Dollars to Words 0
Eliminate blanks while copy row and transpose 11
transpose skip zeros(0's) 2
transpose skip 0's and blanks 3
find first empty cell in column and start transpose next row in that cell 3
Conditional Formatting - Selective Cell Highlighting 5
Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
Need Help with a VBA subroutine 0

Top