software

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:C2A1: 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 quot;mergequot; 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: www.excelforum.com/member.php...foamp;userid=6385
View this thread: www.excelforum.com/showthread...hreadid=509295
For this solution you will need an extra cell eg. H1, where you write
=A1amp;B1amp;C1.
The ambersant (amp;-sign) connects the content of te cells. If you need to
put in helping words you must put the between quotes, like this:
=A1amp;quot; has the following characteristic quot;amp;B1amp;C1

NSV--
nsv
------------------------------------------------------------------------
nsv's Profile: www.excelforum.com/member.php...oamp;userid=26500
View this thread: www.excelforum.com/showthread...hreadid=509295Is it always 2 rows you want to quot;mergequot; if the 1st column has identical
entries i.e. are there always 2 rows with quot;Attribute 1quot; in column A and
then 2 rows with another say Attribute 2?

Hans
Thank you for the help, I wasnt aware that was possible to merge
contents of the cells using quot;amp;quot;. Great tip! I'm sure I will use in the
future. As for my current problem I found another solution by using
Pivot tables and some Macros. Doesnt solve this particular problem but
goes around it.
Thanks again!--
Portuga
------------------------------------------------------------------------
Portuga's Profile: www.excelforum.com/member.php...foamp;userid=6385
View this thread: www.excelforum.com/showthread...hreadid=509295