"Merge" cells

P

Portuga

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!
 
N

nsv

For this solution you will need an extra cell eg. H1, where you write
=A1&B1&C1.
The ambersant (&-sign) connects the content of te cells. If you need t
put in helping words you must put the between quotes, like this:
=A1&" has the following characteristic "&B1&C1

NS
 
F

flummi

Is it always 2 rows you want to "merge" if the 1st column has identical
entries i.e. are there always 2 rows with "Attribute 1" in column A and
then 2 rows with another say Attribute 2?

Hans
 
P

Portuga

Thank you for the help, I wasnt aware that was possible to merge
contents of the cells using "&". 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!
 
Top