paste data omiting blank values

H

hsg

My data is like this:
A B C D ...... I
J
1 1 2 3 4 9
10
2 2.5 0 5 4 0
3.5

when I transfer these two rows, only those columns should be transferred
which do not have "zero" in second row. But this leaves blank in between
column, i would like to remove those blanks, and the pasted data should
be in consecutive columns.

Like in above case, I should get columns A, C, D and J in another worksheet
as columns A, B, C, D

pl help
 
C

CVinje

Perhaps this could produce a more thorough result, but I discovered a way to
copy the data to a new sheet, omitting blank columns - the problem is that it
only works one row at a time. If I understand what you're trying to
accomplish correctly, this process may work:

Select cells containing data in a row (you can simply click the row number
to highlight the entire row).
Tap F5
Click Special in the Go to Box
Check Constants
Hit OK
Hit CTRL + C or Edit, then Copy
and then copy and paste to new sheet

Credit to:
http://www.eggheadcafe.com/conversation.aspx?messageid=30227640&threadid=30227637

What I meant by maybe somebody helping out more is perhaps a macro could be
written to accomplish this in a more automatic / quicker manner.

CVinje
 
J

JBeaucaire

Highlight the cells to copy
Press F5, click SPECIAL
Select Constants, click OK
Ctrl-C to copy
Click on the first target cell and press ENTER.
 

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

Top