paste data omiting blank values
 

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

paste data omiting blank values
 

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/conversat...did=3022 7637

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


"hsg" wrote:

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

paste data omiting blank values
 

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.


hsg;246903 Wrote:
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


--
JBeaucaire
------------------------------------------------------------------------
JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=68900