Fill in Data from Columns that are not Blanks

[wwce]

Hello, I have data with multiple rows of "Parent" and "Kid" and "Address".

However, the "Address" column does not have all the rows filled out, some are blank.

See example:

Parent​	Kid​	Address​
Johnny Jackson​	Anne​
Johnny Jackson​	Suzy​	123 Main St.​
Johnny Jackson​	Junior​
Eric Lee​	Mike​
Eric Lee​	Samuel​	456 Cat Ave.​
Eric Lee​	Noah​
Eric Lee​	James​	456 Cat Ave.​
Eric Lee​	David​
Sarah Connelly​	Charles​
Sarah Connelly​	Beth​
Sarah Connelly​	Ryan​
Sarah Connelly​	Jean​	789 Love Dr.​

I would like to create a new Address column where basically every line has the address referenced to the same parent.

What excel function should I use?

Index, Sumproduct? Or something else?

Any help is appreciated.

 

[maabadi]

1. first sort all of Data based of Parents & then Address together (Go to Sort and Filter , Custom Sort)
2. Select all of column address, Press F5
3. Press Special
4. Select Blanks (you see all blank cells selected)
5. In Formula Bar (Fx) write (= above cell ) (if your first blank cell address is C4) then:

=C3

And Very Important Press Ctrl+Enter

6. Now copy all of column address and then Paste values at the same cells.

 

[Peter_SSs]

I would like to create a new Address column where basically every line has the address referenced to the same parent.

Like this?

20 12 08.xlsm
	A	B	C	D
1	Parent	Kid	Address	All Addresses
2	Johnny Jackson	Anne		123 Main St.
3	Johnny Jackson	Suzy	123 Main St.	123 Main St.
4	Johnny Jackson	Junior		123 Main St.
5	Eric Lee	Mike		456 Cat Ave.
6	Eric Lee	Samuel	456 Cat Ave.	456 Cat Ave.
7	Eric Lee	Noah		456 Cat Ave.
8	Eric Lee	James	456 Cat Ave.	456 Cat Ave.
9	Eric Lee	David		456 Cat Ave.
10	Sarah Connelly	Charles		789 Love Dr.
11	Sarah Connelly	Beth		789 Love Dr.
12	Sarah Connelly	Ryan		789 Love Dr.
13	Sarah Connelly	Jean	789 Love Dr.	789 Love Dr.
Address

Cell Formulas
Range	Formula
D2:D13	D2	=INDEX(C:C,AGGREGATE(15,6,ROW(C$2:C$13)/((A$2:A$13=A2)*(C$2:C$13<>"")),1))