How do i copy a rance and paste to cell listed in column....

[AlexCP67]

I've tried to look this up but can't seem to word my search in a way where i get the wrong the results so i hope someone here can help out.

In the following data set i have 3 columns "E:E F:F and G:G" customer #, keyword and cell value.
I want to run a script that copies the data from all 3 coulmns and paste it by row to the value listed in that rows "Cell" column.
So range E2:G2 gets copied to the cell listed in G2 which is A8.

Thanks in advance for any help!
-Alex

 

[awoohaw]

try:

Book1
	A	B	C	D	E	F	G
1	Customer	Keyword	Cell
2					00045	apple	A8
3					00037	String	A11
4					00001996	John	A14
5
6
7
8	00045	apple	A8
9
10
11	00037	String	A11
12
13
14	00001996	John	A14
15
16
Sheet2

Cell Formulas
Range	Formula
E2:G4	E2	=FILTER($A$2:$C$15,(--(A2:A15<>""))*(--(B2:B15<>""))*(--(C2:C15<>"")))
Dynamic array formulas.

 

[AlexCP67]

try:

Book1
	A	B	C	D	E	F	G
1	Customer	Keyword	Cell
2					00045	apple	A8
3					00037	String	A11
4					00001996	John	A14
5
6
7
8	00045	apple	A8
9
10
11	00037	String	A11
12
13
14	00001996	John	A14
15
16
Sheet2

Cell Formulas
Range	Formula
E2:G4	E2	=FILTER($A$2:$C$15,(--(A2:A15<>""))*(--(B2:B15<>""))*(--(C2:C15<>"")))
Dynamic array formulas.

Took me a second but i actually want to accomplish the opposite of what your formula does.

 

[AlexCP67]

Here is the data i am starting with... my first image in my original post is what i want the final product to be.

 

[awoohaw]

ok,
try this:

Book1
	A	B	C	D	E	F	G
1	Customer	Keyword	Cell
2					45	apple	A8
3					37	String	A11
4					1996	John	A14
5
6
7
8	45		A8
9
10
11	37		A11
12
13
14	1996		A14
Sheet1

Cell Formulas
Range	Formula
A2:B14	A2	=XLOOKUP(C2,$G$2:$G$4,E$2:E$4,"",0,1)
C2:C14	C2	=IF(ISNUMBER(MATCH(ADDRESS(ROW(C2),COLUMN(C2)-2,4),$G$2:$G$4,0)),ADDRESS(ROW(C2),COLUMN(C2)-2,4),"")

 

[AlexCP67]

Thank you so much, this is exactly what I needed! I appreciate the help and wisdom you have bestowed on me!

 

[awoohaw]

I'm pleased you found a solution. Welcome to the forum!

but I think i missed the keyword portion. I'll post a more complete mini in a moment.

 

[awoohaw]

Mr excel questions 39.xlsm
	A	B	C	D	E	F	G
1	Customer	Keyword	Cell
2					45	apple	A8
3					37	String	A11
4					1996	John	A14
5
6
7
8	45	apple	A8
9
10
11	37	String	A11
12
13
14	1996	John	A14
AlexCP67

Cell Formulas
Range	Formula
A2:A14	A2	=XLOOKUP(C2,$G$2:$G$4,E$2:E$4,"",0,1)
B2:B14	B2	=XLOOKUP(C2,$G$2:$G$4,F$2:F$4,"",0,1)
C2:C14	C2	=IF(ISNUMBER(MATCH(ADDRESS(ROW(C2),COLUMN(C2)-2,4),$G$2:$G$4,0)),ADDRESS(ROW(C2),COLUMN(C2)-2,4),"")

 

[AlexCP67]

Mr excel questions 39.xlsm
	A	B	C	D	E	F	G
1	Customer	Keyword	Cell
2					45	apple	A8
3					37	String	A11
4					1996	John	A14
5
6
7
8	45	apple	A8
9
10
11	37	String	A11
12
13
14	1996	John	A14
AlexCP67

Cell Formulas
Range	Formula
A2:A14	A2	=XLOOKUP(C2,$G$2:$G$4,E$2:E$4,"",0,1)
B2:B14	B2	=XLOOKUP(C2,$G$2:$G$4,F$2:F$4,"",0,1)
C2:C14	C2	=IF(ISNUMBER(MATCH(ADDRESS(ROW(C2),COLUMN(C2)-2,4),$G$2:$G$4,0)),ADDRESS(ROW(C2),COLUMN(C2)-2,4),"")

Thank you so much... I was able to successfully translate the formula in the customer column to work for keyword. I marked your last post as the solution because it does complete it for anyone researching this in the future. Again, i really appreciate the help!