Pull names that left messages

[BijanBorazjani]

We have a data collection sheet that needs to be filtered down even more. The All Data import sheet will need to be filled into Comments import sheet meeting only the criteria that they left a message. There could be upwards of 500-1000 responses but maybe only 100 comments. Just need a flexible way to only import the list one time. Thank you in advance

Customer List Import.xlsx
	A	B	C	D
1	Full Name	Please Share Your Address with the Family	Email	Condolence Message
2	Bijan Borazjani		bijan.borazjani@gmail.com	New Test
3	Tim Smith	123 Sesame Street New York City, NY, 12345	Tim.Smith@Gmail.com	Im Sorry
4	Crisp E Bacon	456 Pickup Ln Lafayette, LA, 70518	Amy.Borazjani@gmail.com	We're so sorry to hear about Crisp
5	Seymour Butts	2717 NW 60th St Oklahoma City, OK, 73112
6	Phil McCrevas	123 Sesame Street New York City, NY, 12345	philcrev@gmail.com	So sorry from the McCrevas family
7	Bijan Borazjani	234 Ask Blvd Beverly Hills, CA, 90210	bijan.borazjani@gmail.com	test
8	John Smith	456 Pickup Ln Lafayette, LA, 70518	James.Gunn@gmail.com	TESTING !@#
9	Amy Borazjani	2717 NW 60th St Oklahoma City, OK, 73112	Amy.Borazjani@gmail.com	This is so sad
10	Bijan Borazjani	123 Sesame Street New York City, NY, 12345	bijan.borazjani@gmail.com	Test 2
11	textbox_sample0 textbox_sample1	234 Ask Blvd Beverly Hills, CA, 90210	john@example.com	Lorem ipsum dolor sit amet, consectetur adipiscing elit. Aenean mollis ultricies interdum. Nullam pharetra vitae lectus eget volutpat. Integer in sodales ligula. Vestibulum pellentesque arcu in est aliquam rhoncus. Curabitur et dui quis arcu scelerisque congue. Pellentesque libero ligula, sagittis a tempus quis, finibus eget erat. Nunc sed tempor nunc. Mauris tempor odio id lorem commodo dapibus. Nulla viverra mi in magna imperdiet volutpat.
12	Bijan Borazjani	456 Pickup Ln Lafayette, LA, 70518	bijan.borazjani@gmail.com	test
13	Bijan Borazjani		bijan.borazjani@gmail.com	Sorry for your loss
14
All Data Import

Customer List Import.xlsx
	A	B
1	Full Name	Condolence Message
2	Crisp E Bacon	We're so sorry to hear about Crisp
3	Amy Borazjani	This is so sad
4	John Smith	TESTING !@#
5	Bijan Borazjani	Test 2
6	Bijan Borazjani	test
7	Bijan Borazjani	test
8	Bijan Borazjani	Sorry for your loss
9	Phil McCrevas	So sorry from the McCrevas family
10	Bijan Borazjani	New Test
11	textbox_sample0 textbox_sample1	Lorem ipsum dolor sit amet, consectetur adipiscing elit. Aenean mollis ultricies interdum. Nullam pharetra vitae lectus eget volutpat. Integer in sodales ligula. Vestibulum pellentesque arcu in est aliquam rhoncus. Curabitur et1.
12	Tim Smith	Im Sorry
Comments Import

 

[Fluff]

How about

=choosecols(filter('All Data import'!a2:d2000,'All Data import'!d2:d2000<>""),1,4)

 

[BijanBorazjani]

How about

=choosecols(filter('All Data import'!a2:d2000,'All Data import'!d2:d2000<>""),1,4)

That worked like a charm. Thank You for the quick response!

 

[Fluff]

You're welcome & thanks for the feedback.