Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
"Merge" cells
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do you "select locked cells" w/o "select unlocked cells"? | Excel Discussion (Misc queries) | |||
Counting empty cells within a range of cells | New Users to Excel | |||
Counting only active cells | Excel Discussion (Misc queries) | |||
Help adding text values | Excel Worksheet Functions | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions |