How to transfer data and ignore blank cells

[Darreno]

I need to get data from a range, ignore the blank cells, & transfer to a different range - just like the attached screen shot. Appreciate any advice.

12-27-2012 10-55-43 AM.jpg

[Melvinrobb]

Do you want formulas or are you planning to copy and paste?

[Darreno]

Formulas would be great. I tried copy, paste values, select range, Ctrl-G, special, select blanks but got "No cells were found" message even though there are blank cells. Thanks!

[Melvinrobb]

You probably had a formula that returned a "". Excel doesn't recognize that as blank, even if you have pasted values. Quite Frustrating.
You could sort horizontally. I guess that would only work if you did each row manually. I'll let you know if I think of something.

[Melvinrobb]

the following formula should work:

Please Login or Register  to view this content.

Then Go-To-Special, Formula-Errors. Delete the errors, and you'll be set.

[Darreno]

Wonderful! Thanks.