I want to copy the data into another column but leave out the blanks and the corresponding data rows containing blanks.. how can i do it..
I'll try to clarify my point by this example..
Suppose the data looks like this
column A Column B
1 Sam
2 Sandy
3 Jim
(blank) Sarah
4 Roger
(blank) Andrew
5 Kevin
(blank) Brian
6 Matthew
And i want something looking like this leaving the entire rows of blank data..
Column C column D
1 Sam
2 Sandy
3 Jim
4 Roger
5 Kevin
6 Matthew
What formula should i use??
Hi,
Highlight all your data
Go to Data > Filter > Autofilter
Press the Arrow that appears in column A
Select non blanks
Copy the range and paste as required
Rule 1: Never merge cells
Rule 2: See rule 1
"Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".
Query solved. Thanks. You can lock this topic now.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks