Not sure if its the title is the appropriate but here it goes:
I have the following information after a Vlookup and a formula in Cells
A1:C2
A1: Atribute 1 B1: Blue C1: is a blank cell
A2: Atribute 1 B2: is a Blank Cell C1: RED
I would like to basically come up with one single row where the blanks
are dircarded and "merge" the relevant information maintained, without
copying and pasting because the number of rows is extensive. Basically
I need:
D1:Atribute 1 E1: Blue F1: RED
Thanks!
--
Portuga
------------------------------------------------------------------------
Portuga's Profile:
http://www.excelforum.com/member.php...fo&userid=6385
View this thread:
http://www.excelforum.com/showthread...hreadid=509295